Inoffizielles deutsches Xbase-Forum

How is it possible to switch to BOLD font ? ------------------------------------------------------------------------------- oFont1:=oBook:BookAddFont() // reuse object is OK. oFont1:FontSetName("Tahoma") oFont1:FontSetSize(11) ---------------------------------------------------------------...

If you want to use SQL ; don't waste your time by trying ODBCDBE.

With xbase ODBCDBE you can face a lot of strange string variable errors that you can never find out the reason of it.

I would advise you all SQL EXPRESS !!!!

FACTS ABOUT XBASE++ and SQL; If there is a NULL related the field --> change the SQL select command; instead of; WERNER="SELECT TOP 100 MOULDTYPE,ORDERNO,ORDERITEMNO FROM FROM ACIK_SATISSIPARISLERI;" USE (WERNER) VIA ODBCDBE the corrected is below; WERNER="SELECT TOP 100 ISNULL(MOULDT...

I started new working with this library. LIBXL is great library for preparing EXCEL sheets but the samples/documantation for xbase are too much insufficient. See below a sample: How can i change the color a certain cell ? How can i format a cell like 999,999.99 for numbers ? Does anyone have sample ...

Whenever a NULL is equal to a field other fields will be effected too.

I think this should be not a big deal fixing those kinds of problems for XBASE ++ ALASKA TEAM.

From now on I will continue my trials with SQL LIBRARY...

?type((FIELDGET(1))) ----> N (numeric field) This field is a numeric field but during skip sometimes it appears like EMPTY. That's why i get errors. Whenever i added EMPTY condition it worked but the interesting part is numbers look like empty even i see that there is a nr data. Whenever the field m...

i get written for

?fieldname(1) --> SIPARISOLUSTURMATARIHI

@1,1 say FieldName(SIPARISOLUSTURMATARIHI) ---->I GET THIS ERROR BELOW !!! WAIT "--" ------------------------------------------------------------------------------ ERROR LOG of "C:\ALASKA2\00-TRIALS\SQL-X02\SQL-X02.exe" Date: 11/28/2017 15:26:07 Xbase++ version : Xbase++ (R) Vers...

WERNER="SELECT TOP 100 SIPARISOLUSTURMATARIHI,MOULDTYPE,ORDERNO,ORDERITEMNO,CUSTOMERNO,STOCKCODE,PRODUCTGROUP,OPENTOTAL,TOTAL,CURRENCY,QUANTITY,OPENQUANTITY,SALESENGINEER,DELIVERY_YEAR,DELIVERY_MONTH,DELIVERY_DAY FROM ACIK_SATISSIPARISLERI;" / USE (WERNER) VIA ODBCDBE /* OPEN ORDERS */ Or ...

It's not related with the brackets.

With or without i always get the same error.

Even i write:

@10,0 say 9->SIPARISOLUSTURMATARIHI ---> again i get an error like the same ; like there is no such a variable field

Thank you , it works. I'm new in SQL-XBASE writing ; i do write programs since 1991 in clipper afterwards XBASE 1.80 and recently upgraded to XBASE.2.0. I have another issue now; field from SQL DATABANK --> SIPARISOLUSTURMATARIHI --> During replacing this field to a DBF file i get the error below. M...

During append blank i get error messase . How can i load at program start DBF and SQL DRIVER at the same time ? ------------------------------------------------------------------------------ ERROR LOG of "C:\ALASKA2\00-TRIALS\SQL-X02\SQL-X02.exe" Date: 11/28/2017 00:21:38 Xbase++ version :...

Ist SQLEXPRESS library für XBASE++ besser geeignet anstelle es mit ODBCE zu benutzen ?

Ist es empfehlenswert SQLEXPRESS XBASE++ library lizenz zu kaufen ?

Wir haben Microsoft SQL SERVER in unserem Betrieb ; ich will SQL Daten und DBF Daten (DBFNTX) mit XBASE++ gleichzeitig programmieren.

It works:) The issue is solved. Now i have another problem ; during append blank to .dbf file i get error message. ---> select 9 --> SQL DATABANK ---> select 7 ---> is a normal DBF file (in my directory) During 'append blank' to dbf file this error message arises. Error messag: Error Base/8021 Unkow...

The error is: FILE CANNOT BE OPENED. OPERATION:DbuseArea Thread ID:1 [42S02][208][Microsoft][ODBC SQL Server Driver] Invalid Object name 'SUPER'. Called from MAIN[107] SUPER.DBF cannot be opened ; Actually this database is in the same directory where the EXE is working. I first connected to the SQL ...

]How can I open the DBF file and the SQL databank at the same time ? I can open the SQL datas with xbase 2.0 ; it works fine ; but when I open a dbf file at the same time I get an error.[/b] Sample below: --------------------------------------------------------------------------------- /* Connect us...