|
Hello,
I have a CDatabase object.But the following ExecuteQuery doesn't work.It gives an error "Syntax error in field definition"
CDatabase CurrentDatabase;
CurrentDatabase.ExecuteSQL("Create Table Purchase (Amt decimal(10,2))");
but
the following works
CurrentDatabase.ExecuteSQL("Create Table Purchase (Amt int)");
I have checked with SQL both the statements have right syntax.
What must be the problem?
Prithaa
|
|
|
|
|
prithaa wrote: CurrentDatabase.ExecuteSQL("Create Table Purchase (Amt decimal(10,2))");
Can you execute this statement from within SQL itself? Have you tried:
CurrentDatabase.ExecuteSQL("Create Table Purchase (Amt decimal(10))");or
CurrentDatabase.ExecuteSQL("Create Table Purchase (Amt decimal)");
"Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for, in order to get to the job you need to pay for the clothes and the car and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
|
|
|
|
|
Hello,
Thanks for your reply.
I tried te syntax with Access it did not work in Access.
I want to create a table with a float field.I checked the SQL Create command which says decimal(10,2) for decimal values.
But it doesn't seem to work .
What should I do for decimal vlues?
Prithaa
|
|
|
|
|
prithaa wrote: I checked the SQL Create command which says decimal(10,2) for decimal values.
It matters not what SQL says about the syntax, as you are creating the table within Access. Check its documents instead.
prithaa wrote: What should I do for decimal vlues?
Have you tried:
CurrentDatabase.ExecuteSQL("Create Table Purchase (Amt double)");
"Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for, in order to get to the job you need to pay for the clothes and the car and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
|
|
|
|
|
Hi all,
I am facing strange problem. I am executing A.exe and i wrote code in that binary to update the resource of itself ( that is A.exe itself).. But i am not able to update the resource..Is it permitted ?? I think its not ...even its not giving ny error... whats the problem with it ??
Thnx
LiveShell
|
|
|
|
|
Are you using BeginUpdateResource UpdateResource and EndUpdateResource ?
If possible could you please share your code ?
Regards,
Paresh.
|
|
|
|
|
yeah m using all these apis.. n even call to api returns successful...so i am amazed..
following is the code snippet
HANDLE hResource = BeginUpdateResource(szCVCreatorFile.c_str(), FALSE);
if(hResource == NULL)
{
return false;
}
if (UpdateResource( hResource,
"LICINFO",
MAKEINTRESOURCE(IDR_LICINFO),
MAKELANGID(LANG_NEUTRAL, SUBLANG_NEUTRAL),
pcEncodedData,
uiOutLen) == FALSE)
{
return false;
}
if(EndUpdateResource(hResource, FALSE) == FALSE)
{
return false;
}
|
|
|
|
|
Hi guys.. wanna ask abt a question on c programming.. no c++ or c# but didnt find the right place to post this.. so here goes..
Currently doing a project on c,
aim is to retrived certain field from a .txt file..
my question is do i need to create a structure for that txt file..
if not.. how do i skip a field when readin from a .txt file.??
etc of what in the .txt file
[clientA] [id] [password]
[clientB] [id] [password]
i wanna retrieve the id and password only..
so far i only wanna to opent eh file and print all the info out..
can i use fscanf to do it.
tks guys
the problem i face nw is that the info in the txt file is of different length.
etc.. the clientA name can be 10char n b is 15 char.
i manage to read the strinf from the .txt file and store it into a array[200];
i was tinkin to try to seprate the id and password and store them into different array and use strcmp to check with the user input.
etc from .txt
peter 1111 abcdef
michard 1112 cccbefj
so im tryin to get the id ( 1111 and 1112) out and password abcdef and cccbefj
but im really having a hard time doing so..
|
|
|
|
|
this is what i wrote.. pardon me for such stupid programmin..
#include<stdlib.h>
#include<stdio.h>
#include<io.h>
#include<fcntl.h>
#define EOF (-1)
char passwordchk(char id[],char pw[]);
main()
{
char pw[10];
char id[10];
printf("id:");
gets(id);
printf("\npassword:");
gets(pw);
printf("\nThis if for testing purpose..id=%s\tpw=%s",id,pw);
passwordchk(id,pw);
getchar();
}
char passwordchk(char id[],char pw[])
{
FILE *f;
int i;
int c,count=0;
char buffer[200];
char checker[200];
char id_one[3];
char id_two[3];
char id_three[3];
char one_pw[6];
char two_pw[6];
char three_pw[6];
printf("\nstuff that is pass over to pw function %s,%s\n",id,pw);
f = fopen("passwd.txt", "rt");
while((c=fgetc(f))!=EOF)
{
buffer[count]=c;
count++;
}
printf("\nFrom buffer\n%s",buffer);
fclose(f);
}
|
|
|
|
|
I love C, it is so simple.
If the file was written using structures, then read it using structures of the same size. Now writing it and reading it does involve structure alignment, but that is no different than any other object/record reading. If the file was created specifically to be read as ‘.txt’ then you sill need to know the format and then read it a line at a time
Look at the problem and do not try to over complicate it. The simplest solution is usually the best solutions.
INTP
"Program testing can be used to show the presence of bugs, but never to show their absence."Edsger Dijkstra
|
|
|
|
|
I actually start try out declaring the structure but i got stuck in the mids of doing.
struct record
{
char name[10],personID[10],password[10]
};
this is how i declared.. but the problem is assume the size of password is fix so that ok, i can declared a static one.. but for the pass word and the name.. that can be a problem
etc .txt
peter 1111 abc124
michard 1342 stbjllll
michelle 2312 vjhbvk
so im stucked... i just wanna be able to retieve the id and password from the .txt file then compare it with the user input to check if it correct..
|
|
|
|
|
Looks like ‘Iain Clarke’ gave a reasonable answer to your problem.
As for using structure/record type of format, you would have to place some restrictions on the field sizes, as you have discovered. But since you are dealing with a ‘.txt’ file, attempting to read it using a structure would be a bad idea, as it does not meet the requirement of structured data. Unstructured text data, in the form you presented, should probably be read one line at a time (kind of slow), parsed, and stored internally in any form you wish, including an array of records/structures.
The following is just for my entertainment, but it may give you some ideas:
enum my_field_sizes { REC_NSIZE=32, REC_IDSIZE=10, REC_PWSIZE=12};
typedef struct my_record
{
char name[REC_NSIZE], id[REC_IDSIZE], pw[REC_PWSIZE];
} MY_RECORD;
const char* My_ReadField(const char* pStr, char* pOut, unsigned nOutSize)
{
if( pStr && *pStr && pOut && nOutSize )
{
int i;
while( isspace(*pStr) )
++pStr;
for( i=0; i < nOutSize && !isspace(*pStr) && *pStr; ++i, ++pStr )
pOut[i] = *pStr;
i = (i < nOutSize) ? i : (nOutSize-1);
pOut[i] = ‘\0’;
while( !isspace(*pStr) && *pStr )
++pStr;
}
return(pStr);
}
void My_ReadRecordLine(MY_RECORD* pRec, const char* pLine)
{
const char* pNextField = pLine;
memset(pRec, 0, sizeof(MY_RECORD));
pNextField = My_ReadField(pNextField, pRec->name, REC_NSIZE);
pNextField = My_ReadField(pNextField, pRec->id, REC_IDSIZE);
My_ReadField(pNextField, pRec->pw, REC_PWSIZE);
}
INTP
"Program testing can be used to show the presence of bugs, but never to show their absence."Edsger Dijkstra
|
|
|
|
|
You may only be interested in strings #2 & #3 - but you'll need to read #1 as well. Just throw it away very rapidly!
You need to break the program in to bits.
1/ Open the text file.
2/ Go through it one line at a time
3/ parse the line to get the three thingies from it (sscanf)
4/ throw away Name, and hang on to the other two.
5/ go back to step 2, until you get to EOF (or some other method)
Here is step 3.
Assuming you have a character string with the three words / numbers in it.
char test [] = "iain 1234 clarke";
char password [256];
int id;
while (GetThingsFromLine (test, &id, password))
{
DoStuff (id, password);
}
BOOL GetThingsFromLine (char *test, int *id, char *password)
{
char name [256];
return sscanf (test, "%s %i %s", name, id, password) != 0;
}
I hope that helps a bit!
Iain.
|
|
|
|
|
return sscanf (test, "%s %i %s", name, id, password) != 0;
You haven't got the standard library memorized?  sscanf() returns the number of matches (hopefully 3 in this case) or EOF, not true or false. So although this is the right idea it should probably be an == 3.
(and the %i should be a %d)
David's strtok() suggestion is the way to go in my opinion as it gives you the opportunity to validate the data.
|
|
|
|
|
Hi,
Using a structure will be good. Thts what i feel.
|
|
|
|
|
If there is a unique identifier on each side of the ID, you can read each line of the file, and split it into its (three) parts using strtok(). Although not recommended, you can also use fscanf() to parse each line.
"Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for, in order to get to the job you need to pay for the clothes and the car and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
|
|
|
|
|
You know,the API function GetVolumeInformation()would get a serial number of a device.
But the number is variable,and is not be writen by the productor,so it can be writen again and again.
I want to encrypt some files using the devices firmware serial number.
Some one would like to tell me how to get such information?
Thanks.
GOOD LUCK.
|
|
|
|
|
look at the documentation of the design specifications,
if there is no api, the firmware development team should encode
a firmware function program to pass the handle higher layer
|
|
|
|
|
I'm an ugly guy, have't used CImageList before.
I've viewed some code use CImageList like this.
First declare class members:
CImageList m_imlListCtrl;
CListCtrl m_list;
then
BOOL CMyDlg::OnInitDialog()
{
CImageList imlStack;
imlStack.Create(code);
imlStack.Add(theApp.LoadIcon(IDI_A));
imlStack.Add(theApp.LoadIcon(IDI_B));
m_list.SetImageList(&imlStack);
m_imlListCtrl.DeleteImageList();
m_imlListCtrl.Attach(imlStack.Detach());
}
why not
m_imlListCtrl.DeleteImageList();
m_imlListCtrl.Attach(imlStack.Detach());
m_list.SetImageList(&m_imlListCtrl);
DO TELL ME. or give me some article guides.
|
|
|
|
|
Why not like this.
m_imlListCtrl.DeleteImageList(); <br />
m_imlListCtrl.Create(code); <br />
m_imlListCtrl.Add(theApp.LoadIcon(IDI_A)); <br />
m_imlListCtrl.Add(theApp.LoadIcon(IDI_B));<br />
m_list.SetImageList(&m_imlListCtrl);
The second method you proposed is also ok. but why are you creating a local CImageList object CImageList imlStack; ?
|
|
|
|
|
Except icon you can add your bitmap.
CBitmap bmp;
bmp.LoadBitmap(IDB_MYBITMAP);
pmyImageList->Add(&bmp, RGB(0, 0, 0));
|
|
|
|
|
TO Naveen.R
I'm not familar to CImageList at all.
The code I posted is the source code in EMULE. I'm curious too why use the stack imagelist to set the imagelist of the CListCtrl, while not like your codes.
TO Hamid.
Can load 2 bitmaps like this:
<br />
CBitmap bmp;<br />
bmp.LoadBitmap(IDB_MYBITMAP);<br />
m_iml.Add(&bmp, RGB(0, 0, 0));<br />
<br />
bmp.LoadBitmap(IDB_MYBITMAP2);<br />
m_iml.Add(&bmp, RGB(0, 0, 0));<br />
|
|
|
|
|
But why two bitmaps you can use more files anyway I think my answer was incorrect you use of Bold for font.;P
|
|
|
|
|
|
purplee85 wrote: how i could get gdiplus.h header file?
Download the latest platform SDK.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
