-
did I send you the dll already ?
FK
-
No, but I've been waiting to hear from you regarding it....
-
OK.. try again... let me know when you get it...
-
OK, Frank, I have the latest tornado.dll. Now I need the function name and syntax to use it...
-
should be the same as gridupadteflds. just change the update to add.
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim X As New tornado.z()
X.dbQP = "U=1|S=15|D=Nwind|ni=b5,update,gridupdate,add,grid add|Q=Orders|Th=Title=Grid Edit| bm=orders;0+1|gdf=0,3,4,5,7"
X.dbEditUpdateFlds = "fi=0|type=RONOUPDATE,4,5,7"
X.dbEditGridUpdateFlds = "fi=0|type=RONOUPDATE,5,7"
X.dbEditAddFlds = "0,4,5,7"
X.dbEditGridAddFlds = "fi=0,5"
X.dbDebug = "EditAction"
X.ASPdbNET()
End Sub
</script>
FK
-
Frank,
Here's the error I'm getting:
Compiler Error Message: BC30456: 'dbEditGridAddFlds' is not a member of 'Tornado.z'.
Looks like I do not have the latest Tornado.dll.
The version as reported by TornadoInfo is: ver 4.4.30.11
-
I looked into the latest normal and grid edit implementation and it really needs the corresponding user defeined edit SQL to go with the two modes. Otherwsie, the fields edited in the two modes mustbe the same in which is too restrictive. OK.. now it is done and I'll send you the DLL and test code (bottom of Edit manual page). Confirm the new dbEditGridUPdateSQL and dbEditGridAddSQL for me...
Frank
-
Frank,
Wow! The SQL functions are done, thanks. I'm just back from visiting clients in Michigan and will get to testing the new SQL functions today.
Did you get a chance to post the syntax needed to save data to multiple files?
talk to you later... Paul
-
I added the example to the end of the edit manual page - edit two tables.
Frank
-
Frank,
Is the new file posted to the FTP site we used last time? Paul
-
OH.. I just did that.. I cannot delete the old dll file (access denied) but I did upload the newest dll and hope that it'll overwrite the old one.
let me know..
Frank
-
Frank,
I downloaded the new .dll from the FTP site. Thank you. I'll test out the new functions as soon as I get the multi-table edit/add working.
Having looked at your example I don't see what I'm doing wrong. Here's the error the system is giving.
System.Data.OleDb.OleDbException: Invalid column name 'LocPin'. at System.Data.OleDb.OleDbDataReader.NextResults(IMul tipleResults imultipleResults, OleDbConnection connection, OleDbCommand command) at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Tornado.RS_OleDB.Execute_SQLs(String which, String sql, Int32 recs, Int64& LRecs)
(313 : 7) Error
Edit SQL = INSERT INTO mpoProject (MPOPin,MPOName,mpoNameCode,CreatedDate,FedYear,Co unty,mpoAgency,ObligateDate,AirQuality,IsActive,On StateSystem,Safety,Remarks,LocPin,ProjectBegin,Pro jectEnd,MilePostBegin,MilePostEnd,Distance,PolDist Code,Sponsor,GISData) VALUES ('111999','UCTC','1','6/21/2004','2004','Ulster','City',Null,'AQ Exempt','False','False','False',Null,'111999',Null ,Null,Null,Null,Null,Null,Null,Null)
And, here's my code:
DIM addSql as string = ""
addSql = "INSERT INTO mpoProject (mpoProject.mpoPin"
addSql = addSql & "mpoProject.DOTAuth,mpoProject.mpoName,"
addSql = addSql & "mpoProject.WorkType,mpoProject.IsActive,"
addSql = addSql & "mpoProject.Safety,mpoProject.FunctionClass,"
addSql = addSql & "mpoProject.OnStateSystem,mpoProject.Let_Date, "
addSql = addSql & "mpoProject.County,mpoProject.AirQuality,"
addSql = addSql & "mpoProject.ProjectManager,mpoProject.mpoAgenc y,"
addSql = addSql & "mpoProject.FedYear,mpoProject.CreatedBy,"
addSql = addSql & "mpoProject.UpDatedBy,mpoProject.CreatedDate,"
addSql = addSql & "mpoProject.UpDatedDate,mpoProject.mpoNameCode ,"
addSql = addSql & "mpoProject.Sponsor,mpoProject.AirQuality,"
addSql = addSql & "mpoProject.Remarks,mpoProject.Description)"
addSql = addSql & "VALUES ('mpoPin','DOTAuth','mpoName','WorkType','IsActive ',"
addSql = addSql & "'Safety','FunctionClass','OnStateSystem',#Let_Dat e#,'FedYear'"
addSql = addSql & "'CreatedBy','UpDatedBy',#CreateDate#,#UpdateDate# ,"
addSql = addSql & "'mpoNameCode','Sponsor',"
addSql = addSql & "'AirQuality','Remarks','Description');"
addSql = addSql & "INSERT INTO ProjectLocation "
addSql = addSql & "(ProjectLocation.LocPin,ProjectLocation.Location, "
addSql = addSql & "ProjectLocation.Distance,ProjectLocation.MilePost Begin,"
addSql = addSql & "ProjectLocation.MilePostEnd,ProjectLocation.Map_N umber,"
addSql = addSql & "ProjectLocation.CountyName,ProjectLocation.Corrid or,"
addSql = addSql & "ProjectLocation.ProjectBegin,ProjectLocation.Proj ectEnd,"
addSql = addSql & "ProjectLocation.PolDistCode,ProjectLocation.GISDa ta)"
addSql = addSql & "VALUES ('LocPin','Location','Distance','MilePostBegin','M ilePostEnd',"
addSql = addSql & "'Map_Number','CountyName','Corridor','ProjectBegi n','ProjectEnd',"
addSql = addSql & "'PolDistCode','GISDate')"
.dbEditAddSQL = addSql
I can't say for sure but the SQL Debug does not contain 2 INSERT INTO statements, which are present in the .dbEditAddSQL function. It would seem to me 2 INSERT INTO statements should be there, to differentiate between the 2 tables.
Have tried every trick I know, Some help would be greatly appreciated.
Paul
-
did you try the example in the manual page (as follows)?
<script language='vb' runat='server'>
Sub Page_Load(Source as Object, E as EventArgs)
Dim SQL As String = "SELECT Addresses.ID, Addresses.Address, FLname.LastName, FLname.FirstName FROM Addresses"
SQL &= " INNER JOIN FLname ON Addresses.ID = FLname.ID ORDER BY Addresses.ID"
Dim AddSQL As String = "(|INSERT INTO FLname (ID, LastName, FirstName) VALUES ('[[0]]', '[[2]]', '[[3]]');"
AddSQL &= "INSERT INTO Addresses (ID, Address) VALUES ('[[0]]', '[[1]]')"
Dim UpSQL As String = "(|UPDATE FLname SET LastName='[[2]]', FirstName='[[3]]' WHERE ID='{{0}}';"
UpSQL &= "UPDATE Addresses SET Address='[[1]]' WHERE ID='{{0}}'"
Dim X As New tornado.z()
X.dbQP = "U=1|M=Grid!RowEdit=true|D=MultipleEdit|NI=b5,add, update|PS=-1|TH=Ti= 2 Tables
X.dbSQL = SQL
X.dbDebug = "ActiveSQL, EditAction, EditSetup"
X.dbNameMap = "fi=0|Al=ID|Fo=Addresses.ID, fi=1|Al=Address|Fo=Addresses.address, fi=2|Al=First|Fo=FLname.firstname,fi=3|Al=Last|Fo= FLname.lastname"
X.dbEditAddFlds = "0,1,2,3"
X.dbEditUpdateFlds = "0,1,2,3"
X.dbEditUPDATESQL = UpSQL
X.dbEditADDSQL = AddSQL
X.dbBookMark = "FLname;0"
X.ASPdbNET()
End Sub
</script>
-
Yes, I did. And I don't see how that code will work either. Here's the error it produces.
Format of the initialization string does not conform to specification starting at index 0.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0.
Source Error:
Line 20: X.dbEditADDSQL = AddSQL
Line 21: X.dbBookMark = "FLname;0"
Line 22: X.ASPdbNET()
Line 23: End Sub
Line 24: </script>
Whatever, this means....
Also, to what database do the tables FLName and Address belong. Maybe you should send to me, too. I know saving to multi tables works with aspDB Classic because I was there and did that. Did you look at the debug SQL string I posted? Should that string have 2 INSERT INTO statements? The behavior seems to indicate that the first data element of the second table
(ProectLocation)is unknown. Strange, it's present in the SQL statement! What do you think?
-
did you check out the special example - edit two tables section in the Edit manual page. I tried that and works OK.
Frank
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|