<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16825" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>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?</FONT></DIV>
<DIV><FONT face=Arial size=2>
<HR>
<BR><FONT face=Arial>Kind regards, <BR>Daniel Antonic <BR>Proprietor DCN
Solutions</FONT>
<P><IMG height=21 src="http://dcnsolutions.net/images/logo_l.gif" width=147
border=0><FONT face=Arial size=2> <FONT face=Arial><BR>Mob: 0438 303
429<BR>Email: <A
href="mailto:daniel@dcnsolutions.net">daniel@dcnsolutions.net</A> <BR>Web:
</FONT><A href="http://dcnsolutions.net/"><FONT
face=Arial>dcnsolutions.net</FONT></A></FONT></P></FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=krichardson@viewdale.com.au
href="mailto:krichardson@viewdale.com.au">Kim Richardson</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=phpwestoz@lists.linux.org.au
href="mailto:phpwestoz@lists.linux.org.au">PHP users in Western Australia (or
nearby)</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, May 25, 2009 9:21 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [PHPwestoz] Writing data to
MYOB</DIV>
<DIV><BR></DIV>Daniel,<BR><BR>You'll need to write SQL for inserting data and
updating records. INSERT <BR>into TABLENAME VALUES () etc<BR><BR>Here is a
brief guide. <A
href="http://www.w3schools.com/sql/sql_syntax.asp">http://www.w3schools.com/sql/sql_syntax.asp</A><BR><BR><BR><BR>Daniel
Antonic wrote:<BR>> Hello all<BR>> <BR>> Got another question
on accessing MYOB with php. So far I can read any <BR>> table, aslong as
you get the file unlocked by MYOB. I've set up a <BR>> system DSN, and all
is good except that I can't write data to the <BR>> file! Now I know it has
been unlocked, and its probably due to <BR>> inexperience with ODBC, but
how do you write data to a MYOB ODBC <BR>> Direct v8 database? Do you use a
query, like SELECT * FROM.... etc.? <BR>> (By the way, if anyone wants the
coding for reading info, just email me)<BR>>
------------------------------------------------------------------------<BR>><BR>>
Kind regards,<BR>> Daniel Antonic<BR>> Proprietor DCN
Solutions<BR>><BR>><BR>> Mob: 0438 303 429<BR>> Email: <A
href="mailto:daniel@dcnsolutions.net">daniel@dcnsolutions.net</A> <<A
href="mailto:daniel@dcnsolutions.net">mailto:daniel@dcnsolutions.net</A>><BR>>
Web: dcnsolutions.net <<A
href="http://dcnsolutions.net/">http://dcnsolutions.net/</A>><BR>><BR>>
------------------------------------------------------------------------<BR>><BR>>
_______________________________________________<BR>> PHPwestoz mailing
list<BR>> <A
href="mailto:PHPwestoz@lists.linux.org.au">PHPwestoz@lists.linux.org.au</A><BR>>
<A
href="http://lists.linux.org.au/listinfo/phpwestoz">http://lists.linux.org.au/listinfo/phpwestoz</A><BR>>
<BR><BR>_______________________________________________<BR>PHPwestoz mailing
list<BR><A
href="mailto:PHPwestoz@lists.linux.org.au">PHPwestoz@lists.linux.org.au</A><BR><A
href="http://lists.linux.org.au/listinfo/phpwestoz">http://lists.linux.org.au/listinfo/phpwestoz</A><BR></BLOCKQUOTE></BODY></HTML>