Hi Yvonne,
I already tried that command but it still doesn't work.
Printable View
Hi Yvonne,
I already tried that command but it still doesn't work.
Hi WJ,
Can you try it again. Does it return an error message, can you post a screenshot?
Regards,
Yvonne
Hi Yvonne,
I just tried it and it doesn't work. Here is the screenshot:
Attachment 2029
Hi,
USE command is about (currently selected) cursor. If you use USE, the table stays in database.
DROP TABLE command is about tables inside of database.
You need DROP TABLE and try again.
Hi,
I would
Code:OPEN DATABASE poeoplehr
DIR
* your vt_enterprise is here
DROP TABLE vt_enterprise
DIR
* your vt_enterprise should not be here anymore
create virtualtable vt_enterprise....
Hi Josipradnik,
Right now, It works! Thank you so much for helping me out.
Should I use the browse command and use command to display the table?
Hi,
Yes you can.
If you created vt_enterprise with explicit "where 1=0" you will get empty browse.
Now you can play with pkWhere inside of CREATE VIRTUALTABLE for the purpose of changing it in runtime.
You'll need to drop and create again with "pkWhere=1 eq 0".
Once you create it, you should not execute this CREATE VIRTUALTABLE again
because it will be ready for changing where clause in runtime..
To get some other values in your VT, you will change VT's property PkWhere to be something other than "1 eq 0"
E.g.
If VT's SELECT is ending with: ... where {pkWhere}
Code:mysection = Lianja.get(“page1.section1”)
mysection.setNamedParameter("pkwhere", " nchrperct gt 20")
Hi Josipradnik,
May I know what changes I need to make inside my code to solve this error?
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Executing SQL directly; no cursor. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]An expression of non-boolean type specified in a context where a condition is expected, near 'eq'.
Attachment 2030