Saving Troubles in m110+
Phill Gillespie <[email protected]>
| Newsgroups | gmane.comp.openoffice.dba.user |
|---|---|
| Message-ID | <[email protected]> |
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