FiveTech Software tech support forums

... OLE. ADO has these limitations. We are going to make some necessary changes in xbrowse and other functions to accommodate the specific issues relating to Excel ADO Tables.

... 7 to 16) on the same row 2) same numbers (from column 7 to 16) on different rows when the numbers are colored, I also want to color the columns relating to the headers example "1-4" I want to color the number of columns 1 and 4 the test #include 'fivewin.ch'#include 'xbrowse.ch'function ...

Has anyone had this same problem with the native class? No. I will prepare a sample to test and post here soon. One point, though not relating to your issue: Do not use BETEEN while dealing with DateTime Fields. For example, "AND 2022-01-12 23:59:59" excludes timestamp 2022-01-12 ...

I do not know anything about AI. Confining myself to the programming part relating to lines and cubes (3d geometry), purely out of academic interest. We can use any of the functions hb_jsonEncode(), hb_ValToExp(), ValToPrgExp() of FW_ValToExp(). All these functions ...

Can this also work with multiple dbf's linked ? I believe that only 1 set relation to... scoped can be active at a time... (Not sure) I want a one Xbrowse with 4 dbf linked by a product_id (See a line with product ID and prices from 4 different dbf's) set relation to nofoto->id into ean scoped se...

I am relating two databases, with the corresponding indexed fields, I use Xbrowse lSeekBar to be able to search. It allows me to search all the fields in the main table but NOT the related table field. In the example, I can't ...

... OrdKeyNo() also is effected in the same way. Note: 1. Using oBrw:nLen is faster than using oBrw:KeyCount(). 2. These are issues relating to using the (x)Harbour function OrdKeyCount() but not XBrowse. Thank you Mr. Nages, I use ! Deleted() in index condition to solve this issue.

... OrdKeyNo() also is effected in the same way. Note: 1. Using oBrw:nLen is faster than using oBrw:KeyCount(). 2. These are issues relating to using the (x)Harbour function OrdKeyCount() but not XBrowse.

You want to read all records relating to one invoice, add/edit/delete in memory and save all changes at once to the database. FWH1907 simplifies the entire process. oBatch := oPartRes:ReadBatch( { "INVNUM", nInvoice } ...

Thank you very much for this guide !!

I can do thinks much easier if I do it this way...

THANKSSSSS

All of us are familiar with setting relationships between tables, both for one-to-one relationship and master-child relationship. One-to-one relationship: SET RELATION TO <exp> INTO <other_table_alias> One-to-many (parent-child) relationship: SET RELATION TO <exp> INTO <child_ta...

... table referred to in the main Sql statement. I am assuming that you are getting the error when you double-click on a row for edit. This must be relating to the function "PessoaIncluir()". May we see what is in that function? Are you trying to open able tb_pac in that function?

... TData are tables of items, not items themselves. To get the maximum benefit you will have to do some studying of Object-Oriented Programming (OOP) relating to real world objects. Granted, FW is OOP but relates mostly to interface objects. Using real-world objects in OOP opens up a whole new world ...

... instead to write Fw_OpenAdoConnection to call it ? FW_OpenAdoConnection() is itself a wrapper function. Using this function resolves many issues relating to construction of connection strings yourself. Creating Database oCn:Execute( "CREATE DATABASE <databasename>" ) Creating ...