var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how can i get the link table's DSN and database name?
how to write the code to get the linked table's DSN and Databasename?
as i know the table.connect can return string with all the information with it. But i can't seperate it out.
or anybody know how to get the substring of a string?
for example i has string: ODBC;DSN=XXX;DATABASE=YYYYY
since XXX, and YYY length is unsure, so how can i get the string xxx and yyy?
thanks a llt
Use the mid function and instr
DSNName=Mid(Table.connect,Instr(1, Table.connect,"DSN=")+4, instr(Instr(1, Table.connect,"DSN="),Table.connect,";"))
I have not try this syntax and you must make some adjust.
thanks a lot. it's working
I don't know the instr function before. this one give me good idea how to get substring.