[PHPwestoz] Writing data to MYOB

[Daniel Antonic]

I tried that, but I need to update a record. Now I could DELETE then INSERT, but MYOB doesn't work with DELETE!!! I don't want to end up with extra records, unless you can specify by INSERT which row to put the data in. Any idea what SQL commands are accepted by MYOB ODBC?

--------------------------------------------------------------------------------
 
Kind regards, 
Daniel Antonic 
Proprietor DCN Solutions 
 
Mob: 0438 303 429
Email: daniel at dcnsolutions.net 
Web: dcnsolutions.net

  ----- Original Message ----- 
  From: Kim Richardson 
  To: PHP users in Western Australia (or nearby) 
  Sent: Monday, May 25, 2009 9:21 PM
  Subject: Re: [PHPwestoz] Writing data to MYOB


  Daniel,

  You'll need to write SQL for inserting data and updating records. INSERT 
  into TABLENAME VALUES () etc

  Here is a brief guide. http://www.w3schools.com/sql/sql_syntax.asp



  Daniel Antonic wrote:
  > Hello all
  >  
  > Got another question on accessing MYOB with php. So far I can read any 
  > table, aslong as you get the file unlocked by MYOB. I've set up a 
  > system DSN, and all is good except that I can't write data to the 
  > file! Now I know it has been unlocked, and its probably due to 
  > inexperience with ODBC, but how do you write data to a MYOB ODBC 
  > Direct v8 database? Do you use a query, like SELECT * FROM.... etc.? 
  > (By the way, if anyone wants the coding for reading info, just email me)
  > ------------------------------------------------------------------------
  >
  > Kind regards,
  > Daniel Antonic
  > Proprietor DCN Solutions
  >
  >
  > Mob: 0438 303 429
  > Email: daniel at dcnsolutions.net <mailto:daniel at dcnsolutions.net>
  > Web: dcnsolutions.net <http://dcnsolutions.net/>
  >
  > ------------------------------------------------------------------------
  >
  > _______________________________________________
  > PHPwestoz mailing list
  > PHPwestoz at lists.linux.org.au
  > http://lists.linux.org.au/listinfo/phpwestoz
  >   

  _______________________________________________
  PHPwestoz mailing list
  PHPwestoz at lists.linux.org.au
  http://lists.linux.org.au/listinfo/phpwestoz
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.linux.org.au/pipermail/phpwestoz/attachments/20090525/c9d248be/attachment-0001.htm 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 6599 bytes
Desc: not available
Url : http://lists.linux.org.au/pipermail/phpwestoz/attachments/20090525/c9d248be/attachment-0001.gif