FiveTech Software tech support forums

hi, While creating Excel Table, ADOX can not create more than 7 fields at a stretch and the field MARRIED is the 8th field. where do you read it about 7st Element :?: as i can say your CODE is wrong. you need a "fresh" ADOC.Column ...

about FW_ADOX_CreateExcelTable() : i wonder that FW_ADOX_CreateExcelTable() crash at FIELD "MARRIED" which is not 1st or Last FIELD in DBF Looks like you did not see my working code patiently and jumping at conclusions ...

Whatever DefinedSize we specify while creating the table (via sql or adox), when the table is read using ADO, the field object is showing oField:DefinedSize as 255 only

about FW_ADOX_CreateExcelTable() : i wonder that FW_ADOX_CreateExcelTable() crash at FIELD "MARRIED" which is not 1st or Last FIELD in DBF FIELD "MARRIED" is Type "L", adBoolean but FUNCTION DateCheck() ...

This is an enhanced version. There is an option to use ADOX of SQL to create the table. Both options work alike. Also used datecheck necessary for MS products. #include "fivewin.ch"#include "adodef.ch"function Main()  ...

Some points: 1. I prefer adopting the sql approach than using ADOX. 2. We need to be aware of the limitations of creating Excel sheets using ADO. a) Whatever length we specify, all character columns are VarChar(255) b) Whatever numeric datatype, like int, ...

Yes, we can use ADOX also.

hi, i have found this You need ADOX to do it. This is how you would create the excel file Dim cat As ADOX.CatalogDim tbl As ADOX.TableDim col As ADOX.ColumnSet cat = New ADOX.Catalogcat.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" ...

... create the same table in different RDBMs ( eg Access, MSSQL, MySql, Oracle ). Also FWH function works on those RDBMs which do not fully support ADOX. FWAdoCreateTable( cTable, aStruct, oCn ) // aStruct is identical to DBSTRUCT() Usage: FWAdoCreateTable( "sales", { { BILLNO, ...

... * Supports CMPXCHG16B instruction BMI1 - Supports bit manipulation extensions 1 BMI2 - Supports bit manipulation extensions 2 ADX - Supports ADCX/ADOX instructions DCA - Supports prefetch from memory-mapped device F16C - Supports half-precision instruction FXSR * Supports FXSAVE/FXSTOR instructions ...

Enrico,

Forgot ADOX going into SELECT.

Antonio,

AHF wrote:I know I shouldnt use ADOX!

Please note that ADOX is only supported by Microsoft databases.

EMG

Antonio, Enrico, I know I shouldnt use ADOX! I agree is the best practice. Indexes are for the DB admin to deliver selects rapidly. But dont forget that what we pretend is to change as little code as possible in our app. I could use seek but ...

Antonio,

AHF wrote:Do you code code use index present in the server DB with ADOX? Maybe Enrico has it.

No, I prefer to use WHERE and ORDER BY clauses.

EMG

... DB indexes. Seek cannot be translated to :Find as :Find only works on a single column. Do you code code use index present in the server DB with ADOX? Maybe Enrico has it. Im only missing this to close the first part of adodrdd I hope to post during week end the adordd.