Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 3 of 3 total |
INSERT INTO (ASP-DBISAM) |
Thu, Jul 19 2007 11:05 AM | Permanent Link |
hadt | Please I need an example INSERT INTO in ASP? I can make SELECT without problem but I cannot insert a row |
Thu, Jul 19 2007 11:13 AM | Permanent Link |
hadt | hadt <hdiaztorres@hotmail.com> wrote:
Please I need an example INSERT INTO in ASP? I can make SELECT without problem but I cannot insert a row I use this code and It does not work: Set Conn = Server.CreateObject("ADODB.Connection") Set RS = Server.CreateObject("ADODB.Recordset") Connstring = "DSN=SERVEXTEST;CatalogName=C:\Servex Web\Copy of GROUPESDP\SERVEX\DATA;DRIVER={DBISAM 4 ODBC Driver};ConnectionType=Local" Conn.open Connstring query = "Insert into CALL_JOBS (CJCallNumber,CJJobNumber,CJLabourDuration,CJWorkAction,CJTechnicianNumber) VALUES (2312,4,1,'TRAVAIL',1)" Set RS = Conn.Execute(query) |
Thu, Jul 19 2007 12:04 PM | Permanent Link |
hadt | I found the solution. only I was to change the rights to the users with this file (Write)
|
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |