I have a existing connection handle created in application init
nConnHandle = sqlstringconnect( "DRIVER= .... )
I use this for SPT queries.
I want to create remote cursor initialli with no data and use requery() to get data into it.
In my knowledge, SPT cursors does not allow this.
So I need to create remote view. I want to utilize the exisitng connection handle for this remote view.
I tried the code above but got error "not a character expresion".
How to create SPT cursor which does initially not contain data and can be filled with data using requery() ?
or How to create remote view based on specific connection handle?
nConnHandle = sqlstringconnect( "DRIVER=PostgreSQL;" + ;
"DATABASE=template1;SERVER=localhost;" + ;
"PORT=5432;UID=postgres;PWD=masterkey;B9=0" )
CREATE DATABASE temp
CREATE SQL VIEW myview REMOTE CONNECTION (nConnHandle) AS SELECT * FROM pg_namespace
Andrus