Hi Phill, (not sure if this problem is also "solved" - well, explained - with your latest mail about "unsigned", if so, please discard my mail :)
> This may be related to the "select max()" problems.. > > I have a simple MySQL table connected via ODBC to m113. When I go to > edit an existing record it fails and this appears in the mysql.log file: > > UPDATE Workers SET Course_Int = '1' WHERE RowNum = ' > > (no rownum basically). Are you doing this in a form? > When I use a macro to save the record instead (using uno:RecSave) > > UPDATE Workers SET Sp_Man = '1' WHERE RowNum = & An ampersand sign? Really? And does it work then? > Finally if I add a new record and click save I get this: > > INSERT INTO Workers ( > Ann_Con,Annual_Leave,App_Comp,Bpec_Cert,Bpec_Serv,Bpec_Train,Bupa,Cle,Course_Ext,Course_Int,CSCS,Day,Finance,GCIUICP,IIP,Insurance,Jib,Licensing,Local_Ass,Market,Members,Membership,Number,Overtime,Pension,PHIA,Pipps,Plumbheat,Plutos,PP_Admin,Public_Holiday,QMS,Ray_Brooks,Reg_Off,RowNum,Securities,Sickness,Sp_Man,SP_Training,Sporting,Summit_Skills,Train_Trust,Unvented,Water,Website,Welfare,WPC,Yearbook) > > VALUES ( > '0','0','0','0','0','0','0','0','0','0','0','20050706','0','0','0','0','0','0','0','0','0','0',6,'0','0','0','0','0','0','0','0','0','0','8',Ö > > (cuts off after RegOff with a weird symbol) Provided that you did a copy'n'paste above, this are 581 characters. Hmm, does not really sound like the usual "alocate a 2^n-Bytes buffer and don't care for larger requests" problem, the number is too ... odd for this. If I counted correctly, the value in question is targeted at the RowNum column - what's special about this column? Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
