** Assuming not specified fields accept null Local lnHandle lnHandle=Sqlstringconnect('DRIVER=SQL Server;SERVER=server;Trusted_connection=Yes') Use employee SQLPrepare(m.lnHandle,"insert into Northwind.dbo.employees"+; " (FirstName, LastName,Title,Photo)"+; " values (?employee.First_Name,?employee.Last_Name,?employee.Title,?employee.Photo)") Scan SQLExec(m.lnHandle) Endscan * read back SQLExec(m.lnHandle,'select * from Northwind.dbo.employees', 'SServer') SQLDISCONNECT(m.lnHandle) select SServer browseOr:
lcContent = "0x"+strconv(FileToStr("somefile.ext"),15) SQLExec(m.lnHandle,'insert into myTable (myImage) values (?m.lcContent)')and there are others.