Re: Re: Gui4Cli Internet application

Hi all,

I have been away for some time: It crashes because it cannot open the file. Normally you would avoid this by doing a file-exist test.

The SQLite3 DLL, was never designed/coded with databases existing on webservers in mind. It can work with any file on any location in the world as long as that location is mounted as a network drive. (on slow connections this may not work). Furthermore, I am not sure anymore whether the record locking mechanism works as intended or not. I remember reading some articles on sqLite covering this.

You can still use the GUI4CLI script to manage the database locally, but for remote access, python scripts embedded in the HTML pages might be a better solution to access an sqLite database on a server.

I have used GUI4CLI together with SQLite3.DLL and a database on a server with 70+ users. I used however FTP and intelligent synchronization scripts (in GUI4CLI!) to make sure that all users could update and no information would get lost. This requires a server IP address that is accessible by all users (either within a domain or public). This is likely way to complex for what you want to achieve.

My suggestion again: spend some time with python. The query language is almost the same as the implementation of sqLite3.DLL. It will be more robust and no exe's to distribute.

Best regards,

Jack



________________________________
From: Dimitris Keletsekis <[email protected]>
To: [email protected]
Sent: Thursday, 29 September 2011 12:46 AM
Subject: Re: [gui4cli] Re: Gui4Cli Internet application


  
I suppose that the Open command works ok if you do it through another language?

That would mean that there is a problem with how sgl3 opens files.

Dimitris




On Tue, Sep 27, 2011 at 2:08 AM, Marianne <[email protected]> wrote:

 
>  
>Hi Dimitris
>
>Thank you very much. I am using the Sql3 dll but my problem is the connection string. I do not know what it will be and tried everything. Thought of the following for example:
>
>sql3.Open "http://website/folder/tt.db" mydb #this Fields
>
>but it does not work (gui4cli crashes). 
>
>Regards
>
>Frans
>
>--- In [email protected], Dimitris Keletsekis <gui4cli@...> wrote:
>>
>
>> Hi Frans,
>> 
>> I don't know if this is what you want, but I there is a dll for handling an
>> SQLite database. Last version I have was SQlite 3.
>> 
>> With this you can just use g4c to access the database directly, so if you
>> make a g4c exe which your users can download, it may be all you need.
>> 
>> All the best,
>> Dimitris
>> 
>> 
>> 
>
>> On Thu, Sep 22, 2011 at 10:28 PM, Marianne <marianne976@...> wrote:
>> 
>> > **
>> >
>> >
>> > Dear members
>> >
>> > It is very quiet here at the forum since July this year. However I do have
>> > a question or rather a problem and will appreciate some help.
>> >
>> > I developed an application (information) working on an internal server. I
>> > want to port the application to the Internet. It is a database application
>> > for a university timetable. On the server I use gdb datafiles. For the
>> > Internet I will have to use a database such as Microsoft Access, MySql
>> > (multi-users). (I want to keep GuiCli as the front end. Users will have to
>> > download the application. I actually need a plug-in.)
>> >
>> > All code is written in Gui4cli (with this I do not have a problem.) The
>> > data I can read by using Asp for example (I know a little Asp) but how do I
>> > get the information into Gui4cli. I want to send a query to the the
>> > database, then the result must be send back to Gui4cli where the data are
>> > manipuated and in some cases written back to the database.
>> >
>> > Is there anyone that can give me advice on this. I will appreciate it a
>> > lot. Can it be done or am I too optimistic?
>> >
>> > Kind regards.
>> >
>> > Frans
>> >
>> > 
>> >
>>
>
>