Re: Saving Troubles in m110+

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 -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -