FiveTech Software tech support forums

hi joseluisysturiz

Thank you for your excellent advice. I'll be sure to pay attention to the default values in sql table.

Best regards
Dubravko

Lailton, joseluisysturiz thanks for the help


I think that the function Val2Escape() solve the problem ...

**********************************************************************function Q_UpdateRow(Arg1,aColumns,aValues,cWhere) local cQuery:= "" cQuery = "UPDATE " + Arg1 + " SET " for i ...

Thanks for the quick reply

This is the code that saves:
**********************************************************************function Q_UpdateRow(Arg1,aColumns,aValues,cWhere) local cQuery:= "" cQuery = "UPDATE " + Arg1 + " SET " //--- for i = 1 to len(aColumns) if i = 1 //cQuery ...

Daniel

Is there an working example for update or insert into MySQL database with TDolphin

Afield: = {"id", "sound", "maried", "total", "description", "date_maried"}
Avalue: = {"12345", "c: \ ring.wav". t., 1000, "Kellogg's", "2015-04-10"}

types in SQL are {"CHAR", "TEXT","TINYINT","DECIMAL ...

Hi Baxajaun


According to the definition of Chilkat SSH.dll is:
The SSH / SFTP ActiveX component provides two objects: A client-side SSH2 implementation for executing commands and shell sessions on Unix / Windows SSH servers, and an SFTP implementation for file transfer and remote file management ...

Hi JimTheo,

Do you really have to use the TAPI driver?
I think it's a much better solution for call center SIP (Session Initiation Protocol) based dial and receive phone calls feature.

View http://www.vaxvoip.com/phonesdk.html

Dubravko

Tim

I tried to explain the whole problem (now that I know what is causing the slowness of the app) starting from the MySQL database. When you turn on the computer I start the MySQL database (localhost). Cash in the database is empty. If I send a SQL query on a large table, the first time you are ...

Antonio, Rao

After a more detailed analysis, I found the problem.
Actually, there are two things that affect the above problem.

After the formation of the folder , perform all the functions listed in COMOBOX ... ON CHANGE funx()
Function funx() is actually a SQL query.
I assume that this function ...

Rao,

Thanks for your reply

1) I see that all the time is taken for reading data from the tables.
You need to optimize this area.
The data is read into an array and what you see in the picture is the brows array. Not all the time.

2) Keep aside all windows and dialogs and folders.
Just write ...

Rao,

The system works with a MySQL database.

There are several modes of operation.
1 - Free Mode
The agent logs on to the system and gain FrontEnd
[IMG=http://www.image-share.com/upload/2600/81m.jpg]


From the admin gets the task (Combobox - contry, Conty, Town addres ... etc). Once selected ...

Antonio,

I created only one folder, but the problem is about the same.
After reset the computer, the first time delay 4 min and every next start almost immediately.

[IMG=http://www.image-share.com/upload/2600/42m.jpg]

Best regards
Dubravko Basic

Initial setap is completely finished, and the connection to the database until it comes to SysLogin() functions .

[IMG=http://www.image-share.com/upload/2598/179m.jpg]

2-Display the main window without data and display progress messase while doing the initial setup.

The main window is formed ...

Rao,

Thank you for your experience

I will describe the flow of the program:
/ / ----------------------------Function Main ()   InitSys ()   DefTableName ()             if TestConecction ()     &nbsp ...

Antonio, Rick

Thanks for the quick reply.

Application when starting, really works well and quickly

Yeah, I'm thinking about crossing the Harbour, but I'm not sure I have a good solution for working with MySQL database !

The first version, works with a PgSQL - (Xbase language) which proved to be ...

Slow Application Launch

When I start my application for the first time after booting the computer (W7 and Linux-Wine) or just reboot the machine, the application needs about 1 to 2 minutes to show the first dialog (main application screen).
After then, at each subsequent application start, the ...