LiveCode Forums.

I want to execute livecode in linemode do it's job and then exit

I thought openstack would help me but I have been trying for a few days now and guess no luck.

Any hints or tips.

I have a simple question, join livecode an

I have a bunch of java files (.java) and I want them to call include them in livecode.
I can start a shell and call the procedure by the following command java -jar getprocess.jar -host param1 and so on.

The problem I have with this Jar method is the ...

Perhaps that is my problem. PHP scripting and URL call is not really my piece of cake.

For one customer I'm not allowed to change the database (SAP BW on ORACLE). I have a readonly account and that is it.

The other customer I have to set the context (user workspace) to retrieve any data at all ...

It would be very nice if you could execute a procedure or function on a database
For example begin Procedure end

Revexecutesql would be perfect
It is in my opinion not nice livecode is not having this feature .

I can use a plugin be standard livecode would be mice

I want to execute plsql package (is an procedure) and it doesn't return a value.
I crashes LIVECODE completly.
BUt the question is can this be done.

This is what I try to do

put "begin callvaluescustomer; end" into tsql
revExecuteSQL databaseid, tsql

Further I have to wait very long.

The packing ...

I had to redefine the enterkey to returnkey then a new row is added.
Still not perfect.

I'm using DGH, for grid control, this works fine.

Expect i cannot add new rows, in the script section i clicked install add row, delete row and so on.

How do I. Manage adding an row in my IOS application.

Cheers, Dj

see also :

http://forums.runrev.com/viewtopic.php?f=49&t=9787

DJ

this is the code i'm using to included my mainstack.

on preopenstack
if "InformationLibrary" is not among the lines of the stacksInUse then
start using stack "InformationLibrary"
nzi_preopenstack -- my personal preopenstack
end if
if "DatabaseLibrary" is not among the lines of the ...

Klaus there is a difference that I forgot to check if a file exists. so I replaced the file everytime.
dixie didn't include the copy part but the check exists part.

so the fix for me was that I had all the right command's but not in the right order. to obvious perhaps :roll:
By way the the next ...

dixie helped me thks.

SOLUTION FOR ME

set the defaultfolder to specialFolderPath("documents")
if there is a file "shapdata.dbf" then
put revOpenDatabase("sqlite", pathNdb,,,,,,) into gConID
else
put specialFolderPath("documents") & "/shapdata.dbf" into tMainStackPath
put specialFolderPath ...

on mouseUp
try
set the defaultfolder to specialFolderPath("documents")

put "shapdata.dbf" into pathNdb
put revOpenDatabase("sqlite", pathNdb,,,,,,) into gConID
catch theError
answer info "Problem Opening Database: " & pathNdb & " " & theError
put 0 into gConID
exit mouseup
end try
answer ...

Brr niceit's working in the IOS simulator now, I see the data.
But when I run the application on the ipad the datafield remain empty.

I tried the statement with and without the ; both options are failing on the ipad.

revebderr , database error no such table DJAN

on mouseUp
set the defaultfolder ...

thx dixie i give it a try.


DJ

I was working on a simple app with sqlite.
The problem is when I browse the IOS file system on my ipad I can see the the database file is located in the documents direcotory
I simplified the code :
put specialFolderPath("documents") & "/shapdata.dbf" into tMainStackPath
put specialFolderPath ...