[PHPwestoz] Writing data to MYOB

[Kim Richardson]

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
>