Hi,
i am using mysql c api to send some queries to mysql server which is on
another computer (100MBit almost next to the client)
in my code i am doing this
if (mysql_real_query(mysql,query,strlen(query)))
{
fprintf(stderr,"In query : \"%s\"\n",query);
fprintf(stderr,"Error occured : %s\n",mysql_error(mysql));
}
and this sometimes (e.g. 1 from 1.000.000 sends) do this :
In query : "insert into TR_ITEMS_TEMP (PLU_ID,SOL_PRICE,VOIDED,TR_ID,DPH,DELETE_INDEX)
values (-70,500,0,8052,2,8301)
"
Error occured : Unknown column 'QR_ID' in 'field list'
In query : "insert into TR_ITEMS_TEMP (PLU_ID,SOL_PRICE,VOIDED,TR_ID,DPH,DELETE_INDEX)
values (-70,500,0,8052,2,8301)
"
do someone know what should be the problem?
Server is Win2K and has latest mysql server installed client is the one
from RedHat 7.3 (3.23.49) (=`mysql_config --version`)
Can someone help me? Thanks.
Krata
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
