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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.