Click here to Skip to main content
16,005,141 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralC1010 Error Pin
Mad Docs Hairy Belly6-Oct-03 9:14
Mad Docs Hairy Belly6-Oct-03 9:14 
GeneralRe: C1010 Error Pin
David Crow6-Oct-03 10:45
David Crow6-Oct-03 10:45 
GeneralRe: C1010 Error Pin
Mad Docs Hairy Belly7-Oct-03 11:11
Mad Docs Hairy Belly7-Oct-03 11:11 
GeneralRe: C1010 Error Pin
David Crow8-Oct-03 2:34
David Crow8-Oct-03 2:34 
GeneralCEdit control scroll bar problem Pin
haritadala6-Oct-03 8:53
haritadala6-Oct-03 8:53 
GeneralRe: CEdit control scroll bar problem Pin
Johann Gerell6-Oct-03 10:53
Johann Gerell6-Oct-03 10:53 
GeneralRe: CEdit control scroll bar problem Pin
haritadala6-Oct-03 11:55
haritadala6-Oct-03 11:55 
GeneralODBC issues?? (General error.syntax error) Pin
OARH6-Oct-03 8:49
sussOARH6-Oct-03 8:49 
Hi,
I've been working on a project for a while, but I have run into a speed bump, my query works fine on any SQL connection to my Informix Database, but I just can't get VC++ to run it. It runs as long as I don't add the COUNT(*) and GROUP BY expressions, but as soon as I add that I get the General error.syntax error. Any help or ideas will be appreciated!! Here it is:

INSERT INTO acnd_upc (upc, dist)
SELECT store_upc.upc, count(*) from store_upc, link_link, store, division
WHERE store_upc.linxscd=link_link.linxscd
AND link_link.store_id = store.store_id
AND store.division_id = division.division_id
AND division.channel_id = 'XX'
AND division.first_cycle != '9999-99'
AND dist = 1
AND upc = '99999999999'
AND date_stamp = (SELECT MAX(date_stamp) from store_upc
where upc = '99999999999')
GROUP by store_upc.upc

Thanks!
GeneralRe: ODBC issues?? (General error.syntax error) Pin
Richard Jones7-Oct-03 3:26
Richard Jones7-Oct-03 3:26 
QuestionPopup menu items rect ? Pin
Member 550206-Oct-03 7:15
Member 550206-Oct-03 7:15 
AnswerRe: Popup menu items rect ? Pin
Terry O'Nolley6-Oct-03 11:25
Terry O'Nolley6-Oct-03 11:25 
GeneralRe: Popup menu items rect ? Pin
Member 550206-Oct-03 13:34
Member 550206-Oct-03 13:34 
GeneralUsing a bitmap created with ms paint Pin
b_girl6-Oct-03 7:03
b_girl6-Oct-03 7:03 
GeneralRe: Using a bitmap created with ms paint Pin
Jason Henderson6-Oct-03 10:48
Jason Henderson6-Oct-03 10:48 
GeneralRe: Using a bitmap created with ms paint Pin
b_girl7-Oct-03 3:21
b_girl7-Oct-03 3:21 
GeneralRe: Using a bitmap created with ms paint Pin
Jason Henderson7-Oct-03 3:54
Jason Henderson7-Oct-03 3:54 
GeneralRe: Using a bitmap created with ms paint Pin
b_girl7-Oct-03 4:23
b_girl7-Oct-03 4:23 
GeneralRe: Using a bitmap created with ms paint Pin
Jason Henderson7-Oct-03 4:43
Jason Henderson7-Oct-03 4:43 
GeneralRe: Using a bitmap created with ms paint Pin
b_girl7-Oct-03 6:39
b_girl7-Oct-03 6:39 
GeneralRe: Using a bitmap created with ms paint Pin
Jason Henderson7-Oct-03 6:54
Jason Henderson7-Oct-03 6:54 
GeneralRe: Using a bitmap created with ms paint Pin
b_girl7-Oct-03 7:57
b_girl7-Oct-03 7:57 
GeneralRe: Using a bitmap created with ms paint Pin
Jason Henderson7-Oct-03 8:49
Jason Henderson7-Oct-03 8:49 
GeneralRe: Using a bitmap created with ms paint Pin
b_girl7-Oct-03 9:51
b_girl7-Oct-03 9:51 
GeneralRe: Using a bitmap created with ms paint Pin
Jason Henderson7-Oct-03 10:13
Jason Henderson7-Oct-03 10:13 
GeneralRe: Using a bitmap created with ms paint Pin
Terry O'Nolley6-Oct-03 11:17
Terry O'Nolley6-Oct-03 11:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.