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).
When I use a macro to save the record instead (using uno:RecSave)
UPDATE Workers SET Sp_Man = '1' WHERE RowNum = &
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)
Are there issues with MySQL, ODBC and m110+? I'm off to try to setup
JDBC and see what happens...
P h i l l
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
