C / C++ / MFC

CLongBinary Limited to 255 Bytes

14-Aug-14 21:12

You can use XmlLite[^] to write simple XML data.

Re: Parsing in C/C++

jschell15-Aug-14 9:24

jschell

15-Aug-14 9:24

Member 10125032 wrote:
We have deployed a kit ...My first task is to write a c or c++ program which can parse those received frames and format ... in xml format to our own event handler

Steps
- Get the spec for the 'kit' to determine what it stores.
- Read the data.
- Parse it according to what you learned from the spec. It is unlikely that any complex solutions would be required for this (hopefully, but the spec is the source.)
- The parser will create an internal format (list of structs probably) of your own devising. Probably very close to what you want to put into the xml.
- Determine what the xml looks like. Either find out what it already expects. Or design it. If the latter then someone needs to tell you what data they expect. Otherwise you have no idea what you need to get.
- Write the internal format out to xml form based on the previous step.

Drakesal13-Aug-14 21:52

13-Aug-14 21:52

Hi all

I am writing a program to submit some files in a SQL server 2012 the problem is:

when the file size is around 255 KBytes it's all ok, but when the file is greater there is an error on "RecordSet.Update() phase. The error is : "The Pointer Value type Text, NText or image conflicts with the specified column name. ..."

The Column is declared in table as varbinary(max) the code is:

CFile file(szPathFileToOpen, CFile::modeRead);
ULONGLONG filelen = file.GetLength();

        rsAttachments.AddNew();

rsAttachments.m_AttachmentsID=szUniqueID;

rsAttachments.m_FileName=m_ListAttached.GetItemText(0,0);

GlobalFree( rsAttachments.m_FileData.m_hData );

if((rsAttachments.m_FileData.m_hData=GlobalAlloc(GMEM_MOVEABLE,filelen))==NULL)
{
    AfxMessageBox(_T("memory error"));
}

LPVOID pVoid = NULL;
if((pVoid=GlobalLock(rsAttachments.m_FileData.m_hData))== NULL)
{
    AfxMessageBox( _T( "memory error" ));
}

file.Read(pVoid, filelen);

rsAttachments.SetFieldDirty( &rsAttachments.m_FileData, TRUE );
rsAttachments.SetFieldNull( &rsAttachments.m_FileData, FALSE );

rsAttachments.m_FileData.m_dwDataLength=GlobalSize(rsAttachments.m_FileData.m_hData );

        rsAttachments.Update();

GlobalFree( rsAttachments.m_FileData.m_hData );

Thanks in advance to the angel will help me.

Giovanni

Richard MacCutchan13-Aug-14 22:17

13-Aug-14 22:17

Where is the code that raises the error and what are the values of the parameters being referenced?

Drakesal13-Aug-14 22:39

13-Aug-14 22:39

i am a novice with a DB programming i have put now a CDBException that return me this:

m_strStateNativeOrigin = "State:37000,Native:7125,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:S1000,Native Blush | :O

,Origin:[Microsoft][ODBC SQL Server Driver]

It's good this?

Richard MacCutchan13-Aug-14 23:21

13-Aug-14 23:21

Sorry, that means nothing. You need to show the exact code that causes the error, and include the values of all the parameters being used.

Drakesal13-Aug-14 23:24

13-Aug-14 23:24

Ok already posted the code the problem occur in the moment i call Update, and when the file is greater than 255kb

David Crow15-Aug-14 3:37

David Crow

15-Aug-14 3:37

So have you stepped into Update(), using the debugger, to see where the exception is being thrown from?

Stefan_Lang14-Aug-14 4:44

Stefan_Lang

14-Aug-14 4:44

Have you verified that GlobalAlloc actually worked? Does file.Read() actually read the full file? Check the return value of the Read function to see how many bytes have been read.

255K doesn't seem that large. However, the Global** functions and the CFile class are ancient, and I wouldn't be surprised if they had some built-in restrictions...

On a sidenote, since you immediately lock the memory after allocation, why do you use GMEM_MOVEABLE? And since you immediately free the memory after use, why do you even use the GLOBAL** functions at all, why don't you simply use new and delete instead? That would be faster, requires less code, and takes less effort to read and understand the code!

GOTOs are a bit like wire coat hangers: they tend to breed in the darkness, such that where there once were few, eventually there are many, and the program's architecture collapses beneath them. (Fran Poretto)

Richard MacCutchan14-Aug-14 5:40

14-Aug-14 5:40

Stefan_Lang wrote:
why

Stefan_Lang wrote:
why do you

Stefan_Lang wrote:
why don't you

Copy & Paste ?

Randor 14-Aug-14 15:18

Randor

14-Aug-14 15:18

Hi,

Drakelor wrote:
when the file size is around 255 KBytes it's all ok, but when the file is greater there is an error on "RecordSet.Update() phase. The error is : "The Pointer Value type Text, NText or image conflicts with the specified column name. ..."

You are probably storing the file into a BLOB column. All SQL columns usually have a maximum size. The error message is probably correct... if you attempt to stuff 256 KBytes into a 255 KByte data field you will obviously get an error.

I suspect that you need to regenerate your database tables. This time choose a larger column size.

Best Wishes,
-David Delaune

Drakesal14-Aug-14 20:12

Automatic Transfer File [Real-TIme]

14-Aug-14 20:12

I finally resolved the issue. I explain to you.

1) Download last SQL server driver.

2) Rebind/Recreate the CRecordset, so it bind with varbinary(max) -> CBYTEARRAY

3) In Recordset Class in the line : RFX_Binary(pFX, _T("[FileData]"), m_FileData,15360000);

increase the last parameter to desidered max dimension (15MB in my case).

4) Write this simple code:

C++

CFile cfFileToSave(szPathFileToOpen,CFile::modeRead);
rsAttachments.m_FileData.SetSize((INT_PTR)cfFileToSave.GetLength());
cfFileToSave.Read(rsAttachments.m_FileData.GetData(),(UINT)cfFileToSave.GetLength());
cfFileToSave.Close();

rsAttachments.SetFieldDirty(&rsAttachments.m_FileData,TRUE);
rsAttachments.SetFieldNull(&rsAttachments.m_FileData,FALSE);

rsAttachments.Update();

All done thanks all Thumbs Up | :thumbsup:

Irwan Saifranto13-Aug-14 12:02

Irwan Saifranto

13-Aug-14 12:02

i've problem within doing my final project, i've a project where the project can be transfer a image continues and real time. the transfer data using UDp SOcket. any referention for me to build it, i don.t know what must i do

Re: Automatic Transfer File [Real-TIme]

CPallini13-Aug-14 21:18

Re: Automatic Transfer File [Real-TIme]

13-Aug-14 21:18

Would you do streaming of the image[^]?
Why did you chose UDP? Are you happy with possible packet loss?
Google is your friend[^].

THESE PEOPLE REALLY BOTHER ME!! How can they know what you should do without knowing what you want done?!?!
-- C++ FQA Lite

Richard MacCutchan13-Aug-14 22:14

C++ Vector Array in Template

13-Aug-14 22:14

Irwan Saifranto wrote:
i don.t know what must i do

A few possibilities come to mind.

Choose a different subject, one that you do understand.
Research the use of UDP sockets, and how to write your own data management protocol.
Switch to TCP and research some of the many samples available on the internet.

Member 1100457313-Aug-14 4:19

Member 11004573

13-Aug-14 4:19

Hi!

i am New Programmer of C++. please tell me how to Use Vector In Template With Return Type.Give Me Any Example With Detail Which Can Help Me In Understanding Of This Problem.

Richard MacCutchan13-Aug-14 4:55

13-Aug-14 4:55

Member 11004573 wrote:
how to Use Vector In Template With Return Type.

You need to be clearer about what you mean by this. There are many samples of vectors, templates and return types to be found on MSDN[^], CodeProject articles and through Google. However, if you have a specific coding issue then please show your code and expalin what errors you have.

CPallini13-Aug-14 8:45

13-Aug-14 8:45

e.g.

C++

template <typename T> T find_max(const vector <T> & v)
{
    //...
}

However, as pointed out by Richard, there are many, many possibilities, without further details cannot help more.

THESE PEOPLE REALLY BOTHER ME!! How can they know what you should do without knowing what you want done?!?!
-- C++ FQA Lite

Stefan_Lang14-Aug-14 2:34

Stefan_Lang

14-Aug-14 2:34

I have to ask: why is it that Richard is leanings sideways in your response? Are you implying he's drunk? Poke tongue | ;-P

CPallini14-Aug-14 2:40

have to modify a prn file which is generated by printer

14-Aug-14 2:40

Yes, Stephan Poke tongue | ;-P

THESE PEOPLE REALLY BOTHER ME!! How can they know what you should do without knowing what you want done?!?!
-- C++ FQA Lite

Member 1091823813-Aug-14 0:53

Member 10918238

13-Aug-14 0:53

I have a prn file which prints bar-code. How can change the barcode value through File IO streams in VC++ 6.0

Kindly help me.

Re: have to modify a prn file which is generated by printer

Satya Chamakuri13-Aug-14 1:17

Satya Chamakuri

13-Aug-14 1:17

Can you tell what effort you put do this till now?

Re: have to modify a prn file which is generated by printer

Satya Chamakuri13-Aug-14 1:21

Satya Chamakuri

13-Aug-14 1:21

See this link , it may help you..

http://www.codeguru.com/cpp/w-p/dll/tips/article.php/c12583/TBarCodeDLLBoard-the-Barcode-Bandwagon.htm[^]

Re: have to modify a prn file which is generated by printer

CPallini13-Aug-14 2:08