Mark, I appreciate the info and I'll take a look at the other thread and see what I can add to the equation.
I haven't tried the legacy drivers as yet.
As mentioned, I have successfully compiled a smaller test db app, did that first so I understood how Rev handled before I dug too deep into the project I'm working on. I just rebuilt that test stack as I type to verify, and it still works.
So I wouldn't think that using the legacy drivers would make a difference, but I will try them just for grins.
I am also using the 3.0.0 tc1 beta and having same results in it.
Btw, just tried something else .. I've a menu as follows to open/close the db directly. it works fine in the dev environment as expected, but here's something else I noticed. It does not even display the 'answer' window when I select 'Close DB' in the standalone.
Menu code:
Code: Select all
on menuPick pWhich
answer "Menu"
switch pWhich
case "Close DB"
--Insert script for Close DB menu item here
sqlCloseDB
break
case "Open DB"
--Insert script for Open DB menu item here
sqlConnectDB
break
end switch
end menuPick
Result:
Dev Environ:
- Pops up 'Menu' in a window
Standalone :
- Nothing occurs
If I choose 'Open DB' ..
Open DB code:
Code: Select all
on sqlConnectDB
answer "Open DB"
put revOpenDatabase("mysql","127.0.0.1:8889","db","user","pw", false) into dbID
answer "Open DB - Result: " & dbID
if dbID is a number then
put "CONNECTED: " & dbID into fld fldDBConnect
set textColor of fld fldDBConnect to green
else
put "DISCONNECTED" into fld fldDBConnect
set textColor of fld fldDBConnect to red
answer dbID
exit to top
end if
end sqlConnectDB
Result:
Dev Environ:
- Pops up 'Open DB' in a window
- Pops up 'Open DB - Result: ' & result # in a window
- Field fldDBConnect changes to 'CONNECTED'
Standalone :
- Pops up 'Open DB' in a window
- Nothing elseoccurs
If I choose 'Close DB' ..
Close DB code:
Code: Select all
on sqlCloseDB
answer "Close DBs: [" & revOpenDatabases() & "]"
put revOpenDatabases() into connectList
repeat for each item c in connectList
revCloseDatabase c
end repeat
answer "Verify DBs Closed: [" & revOpenDatabases() & "]"
put empty into dbID
put "DISCONNECTED" into fld fldDBConnect
set textColor of fld fldDBConnect to red
clrFields 'All'
end sqlCloseDB
Result:
Dev Environ:
- Pops up 'Close DBs: [' open db #'s ]' in a window
- Pops up 'Verify DBs Closed: []' in a window
- Field fldDBConnect changes to 'DISCONNECTED'
Standalone :
- Nothing occurs
The results are making me think that my stack may be corrupt in such a way as to affect the build only on this stack.
If I come across anything further, I'll post it.
Thanks