-
Hi Yvonne Milne,
1) Thanks for submitting the ticket for .dbo files execution.
2) I am not asking about parameter passing to stored procedures. My question was to create temp tables or cursors which I can access when my SP finished. Like in MS SQL
CREATE TABLE #people
(
id INT,
name VARCHAR(32)
)
OR
a temporary table available to a all sessions
CREATE TABLE ##people
(
id INT,
name VARCHAR(32)
)
3/4) I am using Lianja SQL server from the same LAN. How can I tell my network admin to setup IP/hostnames to reduce delay.
Thanks
-
Lianja Team
Hi Naeempk,
2. The TMPNAM() function will give you a temporary filename in the current temporary directory (default for Lianja Server is C:\lianja\server\tmp and for Lianja App Builder C:\Users\your-user\AppData\Local\Temp\ on Windows). You can use this with create table or select .. into table, e.g.
mtmp = tmpnam()
create table &mtmp (...)
3/4 Try putting the IP/hostname mapping in the C:\Windows\System32\drivers\etc\hosts file on the client.
Regards,
Yvonne
-
Hi,
Any update regarding ticket submitted for .dbo files execution in latest release ?
-
Lianja Team
Hi Naeempk,
The '.prg' does still need to be present for stored procedures. I will see if this can be scheduled for resolution.
Regards,
Yvonne
-
Hi Yvonne,
We have many Lianja releases but still we need '.prg' file to execute the stored procedures. Can this be resolved in near future ?
Regards
Naeem
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Bookmarks