I'm unsuccessfully trying to modify gra008 to work with our Enterprise database.
I think the main problem is with my sSql select & set code:
sSql = "Select * " & _ "From POINT " & _ "Where sProjectIDfield = gINTRules.EnterpriseCurrPrjID" Set snPointIDs = gINTRules.CurrentProject.OpenRecordset(sSql, dbOpenSnapshot)
I get nothing returned for snPointIDs.
If i leave off the "where..." then the 1st project in the DB is used (followed by all the others)
any pointers would be greatly appreciated.
Thanks
replace sProjectIDfield with gINTProjectID
Phil WadeDatgelBentley Channel Partner and Developer PartnerE: phil.wade@datgel.com | T: +61 2 8202 8600 & +65 6631 9780
Get the most out of gINT with Datgel Tools.
No luck. I get an error for gINTProjectID
gINTProjectID -> **ERROR** ((10551) Expecting a constant, var name or function name.)
If I try to define gINTProjectID then the set statement returns nothing, so either that is not the fix or I'm defining as a incorrect type.
The quotes were set wrong on the where statement.
sSql = "Select * " & _ "From POINT " & _ "Where gINTProjectID = " & CStr(gINTRules.EnterpriseCurrPrjID)
Answer Verified By: Brett Dening