FiveTech Software tech support forums

Como ser, quiero saber como saber la ultima consulta que que hizo (query)

Code: Select all  Expand view

? oCn:cLastSQL

Also you can view last 10 sql statements executed

Code: Select all  Expand view

XBROWSER oCn:aSQL

This works from FWH2102 onwards.

... Zip VARCHAR(20) ); ``` 5. Insert data into the SQL table: Iterate over the data you extracted from the Excel file and generate SQL INSERT statements to populate the table. You can use SQL commands like INSERT INTO to add records to the table. Here's an example: ```sql INSERT INTO Addresses ...

... new. It pre-dates Clipper ( an old, DOS, compiler ) in many languages. Harbour frees us from that restriction Syntax: Swift ( Apple ) uses ? print statements. Harbour, and FWH, are far more sophisticated Libraries: What functionality is NOT covered in Harbour/FWH Integration: Again with the Clipper ...

The problem with so much of those responses is they contain very generic statements. Clearly the input into the data used for those responses reflects a bias to "what is known" by the person who did the input. It reminds me of the responses Windows ...

... string), while in Clipper, using LOCAL or other keywords without a specific data type is common. Syntax: For example, Clipper uses ? for print statements, which is uncommon in modern languages. Standard libraries: Modern languages often offer more extensive standard libraries and functions. ...

1. With ADS I'm able to test my SQL statements using DataArchitect (ARC32). I get to see errors as well as view the actual result that a given statement would yield. Is there a tool to test your SQLs with Maria DB similar to Advantage ARC? ...

... to appreciate until you understand everything SQL brings to you. ...and since we are on the subject; I wonder: 1. With ADS I'm able to test my SQL statements using DataArchitect (ARC32). I get to see errors as well as view the actual result that a given statement would yield. Is there a tool to ...

... is MODAL and all other windows created are NONMODAL. All dialogs are MODAL by default and dialogs activated with NOMODAL clause are NONMODAL. Statements after ACTIVATE command of MODAL Window (i.e., the 1st window, i.e., the MainWindow) and all MODAL dialogs are executed after the window/dialog ...

ClipValue2SQL

Corresponding in FW is oCn:ValToSQL()

But when you start using FW MySql, you will not find the need to use ClipValue2SQL() or its equivalent. In fact, you will find it not necessary even to prepare SQL statements in most cases.

Please give me a small example using ClipValue2SQL()

... INIT .f. If set to .T., any failed DML (INSERT,UPDATE,REPLACE,DELETE) operation will raise a runtime error. This applies to execution of any DML statements with method Execute() or using methods Insert(...), Upsert(...) and Update(...) This us provided to faclititate grouping of several DML statements/ ...

João, Perfect master Enrique, this is how I see the VARIABLE STATEMENTS. And so it is written in the CLIPPER 5.3 books and manuals. Perhaps, I have misunderstood something wrong that you wrote. It doesn't matter, you write your programs his way and I write ...

... la única variable que respeta completamente el principio de encapsulación es la LOCAL. Perfect master Enrique, this is how I see the VARIABLE STATEMENTS. And so it is written in the CLIPPER 5.3 books and manuals. Perhaps, I have misunderstood something wrong that you wrote. It doesn't matter, ...

... INIT .f. If set to .T., any failed DML (INSERT,UPDATE,REPLACE,DELETE) operation will raise a runtime error. This applies to execution of any DML statements with method Execute() or using methods Insert(...), Upsert(...) and Update(...) This us provided to faclititate grouping of several DML statements/ ...

... are NOT stored in the database. You may use whatever date format you like for "display" in your application. If you write your own sql statements for INSERT/UPDATE then use the format 'YYYY-MM-DD' for date constants. But we advise you to use the methods for inserts and updates (which ...

Will be available in the next release. Applies to execution of DML statements "INSERT,UPDATE,REPLACE,DELETE" directly using oCn:Execute() and to methods: method Insert(...) method Upsert(...) method Update() Implemented new DATA lThrowError AS LOGICAL ...