Subscribe Bookmark RSS Feed

using modal to create data base connection

guy_yosef

Community Trekker

Joined:

Jul 16, 2014


Hi

i am trying to create data base connection and data quary using modal

so far i cant retrive the modal text

for example

thi ssi my connection quary: 

dbc

= Create Database Connection("DSN=DB;UID=guy;PWD=passguy;MODE=SHARE;DBALIAS=DB;");

when i try to make a quary so other ppl that dont use JSL can connect to data base i cant retrive the UID

i try:

 

New Window("USER ID", <<Modal, Text Box("insert user ID"), variablebox = Text Edit Box());

userID = variablebox <<get ; 

show(userID) ;

but all i get is:

userID = .;

???

is there a way to create data conection and excute SQL script using new window? (for ppl that are not using JSL)

thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

Hi Guy

You just have syntax error.  You need to use the message "get text", not "get"

Dave

-Dave
2 REPLIES
Solution

Hi Guy

You just have syntax error.  You need to use the message "get text", not "get"

Dave

-Dave
guy_yosef

Community Trekker

Joined:

Jul 16, 2014

thanks

its works fine (took me a while to find the concatenate:)

New Window("USER ID", <<Modal, Text Box("insert user ID"), variablebox = Text Edit Box());
userID = variablebox <<get text ; 


abc = Create Database Connection("DSN=DB;UID="||userID||";PWD=passguy;MODE=SHARE;DBALIAS=DB;");