sqlexpress

Re: MULTITHREADED QUESTION

edimail3@news.nmsc.gov — Wed, 15 Nov 2006 11:48:41 -0500

If I run the backup command from the architect my web application functions 
normally.  I used the backup function to demonstate that a statement that 
takes a long time will hault all other statements until it's complete.  I 
will test further but it seems to be a problem with accessing the database 
through odbc.  I will post the question on the advantage website .

Thanks,

Erik


"Boris Borzic" <ng-at-sqlexpress-dot-net> wrote in message 
news:Xns987C4849D5461SQLExpress@80.32.233.35...
> Hi Erik,
>
> This is really a question for ADS tech support.
>
> I suppose that ADS is locking the database while the backup operation is
> executing. I don't think it has anything to do with ODBC and/or
> SQLExpress, it's just the way ADS is designed.
>
> Best regards,
> Boris Borzic
> -- 
> news://news.Xb2.NET
> http://www.Xb2.NET
> http://www.SQLExpress.net
> industrial strength Xbase++ development tools
>
> edimail3@news.nmsc.gov wrote in
> news:h5kb4b7yjc0mrmw.151120060336@ANDREA:
>
>> I am having a problem on a xb2.net/sqlexpress/ads web bases
>> application. All libraries are the latest version.  If one thread
>> executes a statement like this:
>>
>> PROCEDURE BU_SYSTEM()
>> LOCAL cStmt := "EXECUTE PROCEDURE
>> sp_BackupDatabase('\\SERVER2\VOL2\Backup\LIVE','')"
>> LOCAL oStmt:=NIL
>> LOCAL oConn := TASK_CONNECT_SQL()
>>
>> oStmt := oConn:NewStatement()
>> oStmt:SQLString := cStmt
>> oStmt:Execute()
>> oStmt:Destroy()
>>
>> RETURN
>>
>> ALL other threads are "paused" until this statement completes.  The
>> TASK_CONNECT_SQL() function opens a new connection to the ADS server
>> so there is not a problem with the requests being "serialized".
>>
>> Am I mission something -or- is the ads odbc/sqlexpress combination
>> unable to process multiple statements at the same time?
>>
>> Any information on this appreciated.
>
>

Re: Problems reaching you.

ng-at-sqlexpress-dot-net@ — Thu, 21 Sep 2006 21:01:33 +0200

"Stu Fraser" <stuart-fraser@shaw.ca> wrote in
news:he4vhxvjvghkven.210920062035@ANDREA: 

> Our accounting department has said they are having trouble getting
> through to you at support@sqlexpress.net in order to renew our annual
> subscription. Can you please email me at stuart.fraser@gov.bc.ca ?

The problem is likely SPAM filters. I have replied to you by email already 
with an alternate email address.

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: Firebird databases

ng-at-sqlexpress-dot-net@ — Thu, 8 Mar 2007 15:56:33 +0100

"Bengt Ovelius" <bengt@gopico.net> wrote in 
news:dk6yizk8cwf3tu1.080320070949@ANDREA:

> I got the question today,
> if XBASE and sqlEXPRESS can access FIREBIRD databases

Yes, you can access firebird using SQLExpress. Simply install the firebird 
ODBC driver on the client machine then create a connection using SQLExpress  
(the same as any other database).

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: e-mail

Sander@pbih.eu — Fri, 17 Nov 2006 13:14:42 +0100

Hi Boris,

Checking again? I did not hear back from you, so now I doubt if you
got my mail's form past week?

regards
Sander
Regards
Sander Elias

-------------------------------------------------------------
xbHCL (http://www.xbHCL.com) the xbase HTML command layer
PBIH  (http://pbih.eu)       Polar Bear International Hosting
-------------------------------------------------------------
also a member off the XXP (http://www.xxp.nl)

Re: SQLDataSet

ramirezosvaldo@prodigy.net.mx — Mon, 29 Jan 2007 18:12:14 -0700

Thanks Boris Borzic

I have another problem

My pc, has 1.9 with SQLExpress++ for it.
But when I send the exe file to my client, I have 1.82
but my SqlExpress++ version for 1.82 does not have some function
like oCursor:getSQLColumn("tra_ref"):length

I want to ask if I download the version for 1.82 and use my key
or I need some one else. ?

Best Regards
Osvaldo Ramirez





> Osvaldo Ramirez <ramirezosvaldo@prodigy.net.mx> wrote in 
> news:wbw6tn7hkl1jh1m.280120072046@ANDREA:
> 
>> I have this error, when I try to compile my project.
>>
>>    [Error] : ALK2102: unresolved external symbol SQLDATASET
>>    [Fatal Error] : ALK4102: 1 external symbols unresolved
> 
> Try adding the following statement in your main procedure:
> 
> REQUEST SQLDataSet
> 
> Best regards,
> Boris Borzic

Re: PostgreSQL and updateable cursors

phil@idep.org.uk — Sat, 13 May 2006 17:27:22 +0100

Rudolf,

> I would like to use PostgreSQL, but it seems that I cannot use functions 
> like oCursor:fieldput(). Is this correct or what does it mean, that I cannut 
> use updateable cursors ?

Don't read too much into it. Step back a moment and think in DBF terms. You
go to a record, and you want to read it into memory, display it to the user,
and allow the user to edit it. Before you read it into memory, you can lock
the record, unlocking the record when the user moves to another record. This
sort of thing is very similar to an updateable cursor, but working only on
the current record. It is usually a bad idea, because the record is locked
regardless of whether the user wants to edit it, and remains locked as long
as the user remains on that record.

An updateable cursor means 'create a dataset, and for each row (record) in
the dataset, apply a lock on the row'.

In SQL, you normally don't bother with locks, but doing so guarantees that
the copy of the record (you only ever see a copy) exactly matches the real
record - in other words, it cannot be updated by anyone else.

In reality, as long as you can uniquely identify a record, you can issue an
update for it.

SQLExpress handles this sort of thing for you automatically (you'd have to
ask Boris how), so you really shouldn't care. The *only* thing that is
important, is that you can't issue the statement:
 
  DECLARE mycursor CURSOR FOR UPDATE [OF <column,...>];

This will cause an error.

You *can* issue SELECT ... FOR UPDATE though, so you can still do it on a
straight dataset.

Regards,
-- 
Phil Ide

***************************************
* Xbase++ FAQ, Libraries and Sources: *
* goto: http://www.idep.org.uk/xbase  *
***************************************

If the beautiful princess that I capture says "I'll never marry you! Never,
do you hear me, NEVER!!!", I will say "Oh well" and kill her.
          [Things I'd do as an Evil Overlord]

Data

fst-procurement@telkomsa.net — Wed, 31 May 2006 09:17:21 +0200

Hi,

I am new to Sql and would like some advice on data formats.

We intend porting our existing application to PostGreSql and advice on which
data format to use would be appreciated. When setting up PostGreSql the
recommended format is Utf8. After purchasing SqlExpress I read in the Docs
that collation should be set to ASCII. Should I set up PostGreSql to use
ASCII data format or should I use some other setting in SqlExpress to agree
with PostGreSql.

Any help appreciated.

regards,

jimmy

Re: sort() method missing

office@c-tec.at — Mon, 20 Feb 2006 11:08:33 +0100

Hello Boris,
thank you, found it
regards
Rudolf

"Boris Borzic" <ng-at-sqlexpress-dot-net> schrieb im Newsbeitrag 
news:Xns976CB65A66BB7SQLExpress@80.32.233.35...
> "Reinthaler Rudolf" <office@c-tec.at> wrote in
> news:b5x8llb2320cxt1.160220060854@ANDREA:
>
>> I get no sort() method in sqldataset() and sqlselect(). What I am
>> missing ?
>>
>
> I don't know, but SQLDataSet class does have a :sort() method. See the 
> help
> file (note, there is no :sort method for SQLSelect).
>
> Best regards,
> Boris Borzic
> -- 
> news://news.Xb2.NET
> http://www.Xb2.NET
> http://www.SQLExpress.net
> industrial strength Xbase++ development tools

Re: Relations

fst-procurement@telkomsa.net — Fri, 22 Sep 2006 15:24:27 +0200

Hi Boris,

Thank you. Works perfectly.

Where do I get a listing of these methods? :refreshchildren() does not
appear in the help docs.

regards,

Jimmy

Re: Relations

ng-at-sqlexpress-dot-net@ — Wed, 20 Sep 2006 05:41:12 +0200

"Jimmy Malan" <fst-procurement@telkomsa.net> wrote in
news:j4m057dfz1ccx40.190920061537@ANDREA: 

> Without the following commands the record pointers are not in sync.
> except for oDtlMat which is the first relation establised.
> 
> Is this correct ?

It should work fine without you explicitly calling :fetchData on the child 
datasets. I wonder if perhaps the problem is in your browser not updating. 
Can you test with minimal additional code (eg. SQLTEST3.PRG).

BTW, I notice that you added ORDER BY statements in all of your SELECT's 
even when it makes no sense to do so, like in this statement:

SELECT * FROM Jcdtl WHERE Accmth=1234 AND category='MAT' AND Jno=xxx
ORDER BY Jno

In many cases, the DBMS will need to create a static cursor first, then 
sort it before it can send you the result set (a very costly operation). 
Unless you know that you have an index on the ORDER BY expression, it is 
best to do the sort on the client side.

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: Relations

ng-at-sqlexpress-dot-net@ — Wed, 20 Sep 2006 16:17:12 +0200

"Jimmy Malan" <fst-procurement@telkomsa.net> wrote in
news:et632nr7xpj4kwd.200920061239@ANDREA: 

>> It should work fine without you explicitly calling :fetchData on the
>> child datasets. I wonder if perhaps the problem is in your browser
>> not updating. Can you test with minimal additional code (eg.
>> SQLTEST3.PRG). 
> 
> After the first setrelation command I checked Jno field of oDtlMat in
> the debugger and it was correct. However after subsequent setrelation
> commands the Jno field in oDtlLab and oDtlSub was incorrect. At this
> point the browser had not been setup.

The relations should be in sync when the parent record pointer is moved.
At the start, you may need to call oParent:RefreshChildren() to get the 
children in sync prior to any record movent.

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

SQLListTables fails at the scond call

office@c-tec.at — Fri, 24 Mar 2006 10:59:59 +0100

Hello,
I have a strange effect when calling SQLListTables in a MY SQL Database. The 
first time it works, but if I call it the second time, I get no tables back.
Any idea ?
regards
Rudolf

function show_tables()
******************************************************************
local oBrowse,aTables := {},nPointer := 1,getlist := {},oCursor,nSuccess
local oConn := MyDefaultSQLConnection(,.t.)
oConn:displayErrors := .t.

oCursor  := SQLListTables():new( oConn)
nSuccess := oCursor:execute()
while ! oCursor:Eof()
     aTmp := {}
     for i := 1 to oCursor:Fcount
          aadd(aTmp,oCursor:fieldget(i))
     next
     aadd(aTables,aTmp)
     oCursor:skip()
end
@ 1,1 DCBROWSE oBrowse DATA aTables SIZE  100 ,30   PRESENTATION 
cstat("BROWSEPRES") ID 'BROWSEET' POINTER nPointer;
          COLOR 
{||{GRA_CLR_BLACK,GraMakeRGBColor(cstat("SYS_BROWSECOLOR"))}}  CURSORMODE 
XBPBRW_CURSOR_ROW;
          DATALINK {||show_cols(oConn,aTables,nPointer)}
DCBROWSECOL ELEMENT  1 WIDTH   10  HEADER 'Table Cat'       PARENT oBrowse
DCBROWSECOL ELEMENT  2 WIDTH   10  HEADER 'Table Schema'    PARENT oBrowse
DCBROWSECOL ELEMENT  3 WIDTH   10  HEADER 'Table Name'      PARENT oBrowse
DCBROWSECOL ELEMENT  4 WIDTH   10  HEADER 'Table Type'      PARENT oBrowse
DCBROWSECOL ELEMENT  5 WIDTH   20  HEADER 'Remarks'         PARENT oBrowse

DCREAD GUI FIT MODAL ADDBUTTONS TO lOk TITLE "Tables"

oConn:destroy()
return .t.

Re: SQLExpress, ADS and deleted records

ng-at-sqlexpress-dot-net@ — Mon, 30 Oct 2006 13:21:17 +0100

"Toma Grom" <tomaz.grom@siol.net> wrote in
news:pgnqwbpmnr4dea5.301020060947@ANDREA: 

> maybe you know what happens, when xBase programmer hide deleted
> records inside .DBF table with command SET DELETED OFF and then with
> an SQL statement request data from the .DBF table.
> Are deleted records hidden or not, I mean, does the cursor (result
> set) brings back only desired data, or mixture of deleted and
> undeleted records ? 

There is no concept of deleted records with SQL. ADS will not return 
deleted records to you using SQL.

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: Ace Wrappers getting started

ng-at-sqlexpress-dot-net@ — Wed, 24 May 2006 07:17:24 +0200

"Mahanimann" <paaldalen@gmail.com> wrote in 
news:8uuqxu26gpyizfa.200520061225@ANDREA:

>    *! Here I would like to connect to the ADS remote
>    *! server (running Win2K with NTFS) on P:
>    *! The ADT's and the dictionary file (SHP.ADD) are
>    *! in P:\Data. The IP-adress is 169.254.0.15
>    *! The network name is "ADVANTAGE"
>    *!
>    *! QUESTION I: How do I connect to the _database_?
>    *!                        (i.e. the dictionary)

You cannot connect to the ADS dictionary with the current version of Ace 
Wrappers. At the time that the ACE Wrappers were written, Advantage did not 
have a dictionary. 

Since you have the source code, you should be able to modify to suit your 
specific needs without too much trouble. 

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: Error connecting SQLExpress to oracle 10g

stuart.fraser@cgi.com — Fri, 1 Dec 2006 10:03:18 -0800

Hi Eugenio,

What ODBC Driver are you using?  I would not recommend the Microsoft one. 
There are limitations.
We always use the Oracle provided drivers here.

To me it looks like you are connecting via a DNS as well.  I have never done 
it this way, but choose to connect directly instead.

Here is some stuff cut and modified from my connection routine.  Note: this 
is an oracle 9i database but it should be relatively the same.

Local cDriver:="Oracle ODBC Driver"
Local cServer:="MyServer"    // put your server name here as it would appear 
in the tnsnames.ora file
Local cUID:="stu"
Local cPW:="mypassword"
Local oConn

Begin Sequence

oConn:=SQLConnection():New()

cConStr:="DRIVER="+cDriver+";SERVER="+cServer+";DBQ="+cServer+";UID="+cUID+";PWD="+cPW

oConn:DriverConnect(,cConStr,SQL_DRIVER_COMPLETE_REQUIRED )
If !oConn:isConnected
 ErrorMsg({"Error Connecting to Server: "+cServer,;
     "As User: "+cUID, ;
     "In The '"+NiceEnviro()+"' Environment"}," Data Mart Error")
 lOk:=.f.
Endif

EndSequence

Hope that helps,

Stu.

"Eugenio Abordi" <eugenioabordi@romeomaestri.it> wrote in message 
news:6lggktf7mdhcscm.281120062237@ANDREA...
> After many tests I solved the problem. The PATH did not include the dir of 
> Oracle:
>
> C:\oracle\product\10.2.0\client\bin
>
> Now I can connect. But the system does not return the database name:
>
> ? "Connected to: ", oConn:DbmsName, ", Database: ", oConn:DatabaseName
>
> oConn:DbmsName display "Oracle"
> oConn:DatabaseName des not display anything
>
> Do you know why ?
>
> Best Regards.
>
> "Eugenio Abordi" <eugenioabordi@romeomaestri.it> ha scritto nel messaggio 
> news:jc75dee1157hcc1.281120062201@ANDREA...
>>I have tried a little sample like this:
>>
>> oConn := SQLConnection():new('mydb', 'myuser', 'mypasswd')
>> if oConn:isConnected
>>   oStmt := oConn:NewStatement()
>>   oStmt:SQLString := 'SELECT COUNT(*) FROM ANSADID'
>>   if oStmt:Execute() != SQL_XPP_ERROR
>>      MsgBox("SQL OK")
>>   endif
>> endif
>>
>> and I receive a system error 1114.
>>
>> Do you have an example of connection to Oracle 10g db ?
>>
>> Best Regards.
>>
>> "Eugenio Abordi" <eugenioabordi@romeomaestri.it> ha scritto nel messaggio 
>> news:agg8facv2wx5u85.281120062117@ANDREA...
>>> There is no specific error message.
>>>
>>> Previously when I use sqlexpress with Informix with the syntax I wrote 
>>> you the connection start without problems.
>>>
>>> It seems that the program does not found the ODBC connection.
>>>
>>> The syntax I use is correct for Oracle ? Do you have tested SQLExpress 
>>> wth Oracle 10g Release 10.2.0.2.0 ?
>>>
>>> Best Regards
>>>
>>> "Boris Borzic" <ng-at-sqlexpress-dot-net> ha scritto nel messaggio 
>>> news:Xns98898C5A5DC71SQLExpress@80.32.233.35...
>>>> "Eugenio Abordi" <eugenioabordi@romeomaestri.it> wrote in
>>>> news:v1rs5haiih0wlho.281120061831@ANDREA:
>>>>
>>>>> When the program start it shows the ODBC box and then show the box 
>>>>> with
>>>>> "Unable to connect to data source"
>>>>
>>>> What error message do you get?
>>>>
>>>> Best regards,
>>>> Boris Borzic
>>>> -- 
>>>> news://news.Xb2.NET
>>>> http://www.Xb2.NET
>>>> http://www.SQLExpress.net
>>>> industrial strength Xbase++ development tools
>>>
>>>
>>>
>>
>>
>>
>
>
>

Re: Converting character string

ng-at-sqlexpress-dot-net@ — Thu, 21 Jun 2007 14:10:39 +0200

"Toma Grom" <tomaz.grom@siol.net> wrote in
news:litzorhw7ytdrou.210620071005@VDS-472773: 

> Boris, my tests included only few data fields. And in such
> circumstances ADS API is quicker, then SqlExpress.
> 
> But if they are many, SQLExpress speed accelerates in comparison to
> ADS API.

Thanks for the update.

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: Converting character string

tomaz.grom@siol.net — Fri, 15 Jun 2007 08:26:53 +0200

Hello, I have to correct myself.

Further investigation shows, that xBase++ functions ConvToAnsiCP( 
<cOemFormatString> ) and vice versa works with both, SQLExpress and pure ADS 
API calls.
But prooper functioning demands transformation to ANSI when making SQL 
request sentence and later back to OEM, while retreiving the data from the 
server.

Speed difference remains. For samaller data amound  1 : 2 , for bigger up to 
1 : 6.

Best regards

Toma

Re: vacation alert

ng-at-sqlexpress-dot-net@ — Tue, 8 Aug 2006 09:08:34 +0200

Hi Jim,

You should know better you're in the software business too <g>.

I wish I could afford to take that much time off. It's more like a 
working vacation. I'm visiting family in Europe and brought my computer 
along to do some work. Unfortunately, Internet access here is very 
sparse.

Best regards,
Boris Borzic
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools 

"Jim Graham" <J.GRAHAM@PROTELEDATA.COM> wrote in
news:pf0qdb1l1bnasrf.280720062101@ANDREA: 

> Hmmmm...
> 
> Consulting and sales must be good.  A one month vacation!!!
> 
> Enjoy...
> 
> 
> "Boris Borzic" <ng-at-sqlexpress-dot-net> wrote in message 
> news:Xns980C4EA1996EDSQLExpress@80.32.233.35...
>>I will be on vacation with very limited email access and probably zero
>>news 
>> group access until August 28'th. Please do not expect me to personaly
>> answer any questions posted on this NG until after August 28'th.
>>
>> Thank you & kind regards,
>> Boris Borzic
>> http://www.Xb2.NET
>> http://www.SQLExpress.net
>> industrial strength Xbase++ development tools 
>

Re: Date Field that does not accept NULL values

mikewheat@tm.net — Wed, 5 Apr 2006 11:30:21 -0400

Boris,

Other Database Servers do support Non-Nullable columns, just not empty.  You 
can set default values at the data layer.

If the sql server is responsible for default values which most people would 
prefer as apposed to putting in the software.  Let's leave this up to the 
data layer.  Then we perform an insert on a DataSet with SqlExpress.  I 
found out the following...

Nullable column - Value after Insert: NULL

Shouldn't the value of the column be the default value?
It is NULL because the DataSet is setting the date column to NULL.

Non-Nullable column - Error

This is not nice.  We got this error because the DataSet is trying to set 
the date column with NULL.

This could all be avoided if the DataSet was not trying to set the date 
column to NULL.  If you prefer to continue setting a values for all columns 
by the DataSet, you could check for the default value.

I also found out that if I set default values on the database server for any 
column type, they are ignored by DataSet.

Thank you,
Mike

Re: Converting character string

ng-at-sqlexpress-dot-net@ — Fri, 15 Jun 2007 14:27:54 +0200

"Toma Grom" <tomaz.grom@siol.net> wrote in
news:68jk7n8nqoy3jl5.150620070827@VDS-472773: 

> Further investigation shows, that xBase++ functions ConvToAnsiCP( 
><cOemFormatString> ) and vice versa works with both, SQLExpress and
>pure ADS 
> API calls.
> But prooper functioning demands transformation to ANSI when making SQL
> request sentence and later back to OEM, while retreiving the data from
> the server.

You should be able to avoid all of this conversion by setting your ADS 
database as ANSI and in Xbase++ "SET CHARSET TO ANSI"

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: Is this the correct flow for error catching in Transactions?

mikewheat@tm.net — Wed, 1 Mar 2006 14:53:39 -0500

Boris,

You are right.  Reconnect() fails anytime after a network failure.
No need to check the connection or call reconnect.

I guess it is a good idea to always stay in a connectionless environment.

Thank you,
Mike


"Boris Borzic" <ng-at-sqlexpress-dot-net> wrote in message 
news:Xns9779550551EEFSQLExpress@80.32.233.35...
> "Michael Wheat" <mikewheat@tm.net> wrote in
> news:txaq5xcfedwlfvx.010320061357@ANDREA:
>
>> One more question for clarity.  If the connection breaks due to server
>> reboot.  After the reboot has completed, if the connection object has
>> not been destroyed and I issue reconnect, will it fail?
>
> The best thing to do is to try it with your server/driver combination.
>
> Best regards,
> Boris Borzic
> -- 
> news://news.Xb2.NET
> http://www.Xb2.NET
> http://www.SQLExpress.net
> industrial strength Xbase++ development tools

SqlDataSet:isRowModified

andrej.obermajer@litija.com — Fri, 22 Sep 2006 13:09:42 +0200

Hi Boris.

What is a point of SqlDataSet:isRowModified function? On MySQL it always 
returns false.

Regards,

Andrej Obermajer

oCursor:locate problem

office@c-tec.at — Tue, 9 May 2006 09:23:49 +0200

Hello Boris,
I have a problem with locating a value from a table.

this line works:
lFound := oCursor:Locate(o:EditBuffer(),"NAME")

this line crashes:
lFound := oCursor:Locate( {|oc|oc:FieldGet("NAME") = 
alltrim(o:EditBuffer)} )

with this error message:

------------------------------------------------------------------------------
ERROR LOG of "H:\GASTS\GASTS.exe" Date: 09-05-2006 09:23:13

Xbase++ version     : Xbase++ (R) Version 1.82.306
Operating system    : Windows XP 05.01 Build 02600 Service Pack 2
------------------------------------------------------------------------------
oError:args         :
          -> VALTYPE: A VALUE: {3333, "teST", "teST", 0, 0, "", "J", "J", 
"J", "", 0, "J", 0, 0, 0, 0, "", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 
0, "", "", "", "", "", "", "", "", "", "", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 
{3333, "teST", "teST", 0, 0, NIL, "J", "J", "J", NIL, 0, "J", 0, NIL, NIL, 
NIL, NIL, NIL, NIL, NIL, NIL, NIL, NIL, NIL, NIL, NIL, NIL, NIL, NIL, NIL, 
NIL, NIL, NIL, NIL, NIL, NIL, NIL, NIL, NIL, NIL, NIL, NIL, NIL, NIL, NIL, 
NIL, NIL, NIL, NIL, NIL, NIL, NIL}}
          -> VALTYPE: C VALUE: NAME
oError:canDefault   : N
oError:canRetry     : N
oError:canSubstitute: Y
oError:cargo        : NIL
oError:description  : Parameter has a wrong data type
oError:filename     :
oError:genCode      :          2
oError:operation    : FieldGet
oError:osCode       :          0
oError:severity     :          2
oError:subCode      :       1025
oError:subSystem    : BASE
oError:thread       :          4
oError:tries        :          0
------------------------------------------------------------------------------
CALLSTACK:
------------------------------------------------------------------------------
Called from (B)_SEARCHITEM(124)
Called from (B)SQLDATASET:LOCATE(888)
Called from SQLDATASET:LOCATE(888)
Called from _SEARCHITEM(124)
Called from (B)EDIT_ITEM(83)
Called from DC_XBPGET:KEYBOARD(1334)
Called from DC_GETLIST:EVENTLOOP(3861)
Called from DC_GETLIST:READGUI(3323)
Called from DC_READGUI(223)
Called from EDIT_ITEM(94)
Called from (B)PROG_START(0)

any idea ?
regards
Rudolf

Sort method

fst-procurement@telkomsa.net — Tue, 22 May 2007 15:32:09 +0200

Hi Boris

Won't you please consider adding a sort method to a server side cursor ?


regards,

Jimmy

SQL data snapshot independency

tomaz.grom@siol.net — Thu, 14 Dec 2006 11:10:22 +0100

I am not shore, how different SQL statements interacts with each other.
Can you please clear me out the following situation.

1. Prepare the cursor data
    oCursor --> SELECT FROM MyTable WHERE MarkerField = False 
(SQL_CONCUR_READ_ONLY, SQL_CURSOR_FORWARD_ONLY)

2. Ruin the WHERE condition from previous select
    UPDATE MyTable SET MarkerField = TRUE WHERE MarkerField = FALSE

3. Do some tasks with a cursor
    oCursor:goTop()
    DO WHILE !oCursor:eof()
        ....
    ENDDO

Is the cursor from first line independent from changes, caused just after ?

I know, this is not SQLExpress question, but anyway, in my first steps to 
SQL apporach I want to clear some things out.

Best regards

Toma

Re: Unloading DLL problem

vjharris@starband.net — Wed, 2 Aug 2006 07:18:35 -0500

Sander,

I followed your lead and added a destory to oConnReid and a nil... in the 
loop..
   DO WHILE .t.

     oConnRefid := LCS_SQL_Connection(,Trim(SIFServerCommand))
     M->oCursorRefIds := CreateSifRefIdsCursor( oConnRefid )
     oConnRefid:Destroy()
     oConnRefid := nil
     oCursorRefIds:Destroy()
     oCursorRefIds := nil

   sleep( 100 * 15  )   // runs every 15 seconds

   ENDDO
That did the trick... wow... this has been driving me nuts...

Thanks
Jeanne
>

Re: Newbie question

lmaher@paradox.ca — Mon, 6 Nov 2006 14:45:30 -0500

Thanks Boris,


"Boris Borzic" <ng-at-sqlexpress-dot-net> wrote in message 
news:Xns987393CA94911SQLExpress@80.32.233.35...
> You cannot return a SP param value back to SQLExpress (output params are
> not supported).
>
> What you can do however, is to generate a resultset in the SP and return
> the required data like a cursor. In this case you sould need to call the 
> SP
> from an SQLSelect instance.
>
> Best regards,
> Boris Borzic
> -- 
> news://news.Xb2.NET
> http://www.Xb2.NET
> http://www.SQLExpress.net
> industrial strength Xbase++ development tools
>
>
> "Lynne Maher" <lmaher@paradox.ca> wrote in
> news:4qrv8k2hv5m4qym.061120061710@ANDREA:
>
>> I have another question now, can I get a return value from a Stored
>> Procedure executed on the server.
>> Ex.:
>> ALTER PROCEDURE SomeStoredProcedure
>> @param1 bigint,
>> @param2 nvarchar(20),
>> @RetVal bigint OUTPUT
>> as
>> ...
>>
>> How do I get the "RetVal" from the procedure into xBase++? I execute the
>> following but how do I get my returned value.
>>
>> oStmt := SQLStatement():New("{call SomeStoredProcedure(?,?,?)}", oConn)
>> nRowsAffected := oStmt:Execute( Param1, Param2, RetVal )
>
>

Re: ADS Connection type

ng-at-sqlexpress-dot-net@ — Wed, 24 May 2006 07:20:44 +0200

"Toma Grom" <tomaz.grom@siol.net> wrote in
news:1phv3n54jjsmwc1.230520062047@ANDREA: 

> Is the connection between xBase program, SQLExpress and ADS native, or
> it should be made through ODBC?

SQLExpress always uses ODBC.

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: vacation alert

phil@pbih.net — Wed, 26 Jul 2006 14:30:25 +0100

Boris,

> I will be on vacation with very limited email access and probably zero news 
> group access until August 28'th. Please do not expect me to personaly 
> answer any questions posted on this NG until after August 28'th.

Happy hunting (or whatever you are up to)!

Regards,
-- 
Phil Ide

-----------------------------------------------------------------
xbHCL (http://www.xbHCL.com)     Xbase++ HTML command layer
PBIH  (http://www.pbih.eu)       Polar Bear International Hosting
-----------------------------------------------------------------
Xbase++ FAQ, Libraries and Sources:
http://www.idep.org.uk/xbase

He who dies with the most software WINS!

Re: Microsoft ODBC for Oracle and Win XP

stuart-fraser@shaw.ca — Tue, 6 Jun 2006 09:43:50 -0700

Boris,

thanks for the feedback.  I'll give it a try.

Had a tech work on the machines in question yesterday.  It would seem it is 
the particular image on those machines only which is a mix of SP1 with some 
SP2 patches.  We also discovered that when you install the Oracle 8.0.6 
client it updates some of the Microsoft ODBC stuff, but not when you install 
the 9i client, which would explain why it suddenlty worked under 8.0.6 on 
these machines.

Anyway I'll try your suggestion and see if it works across the board on all 
builds.  That would be a problem solver for me.

thx again,

Stu.


-- 
Stu Fraser
Senior Programmer Analyst
IBM Managed Operations / BC Ministry of Health
Victoria, BC
"Boris Borzic" <ng-at-sqlexpress-dot-net> wrote in message 
news:Xns97D9CAF5A516CSQLExpress@80.32.233.35...
> "Stu Fraser" <stuart-fraser@shaw.ca> wrote in
> news:0hgiidmn7izr7uk.050620062218@ANDREA:
>
>> I guessed it was ODBC related and tried installing MDAC2.8 but that
>> didn't help.  In the end we upgraded it to SP 2, as it was working
>> fine on my SP2 laptop with the 8.0.6 client installed.  Once we were
>> updated to SP 2 however it still did not work correctly.  So in the
>> end we tried installing the 8.0.6 client and then it worked.
>
> have you tried specifying the date by using the ODBC escape sequence:
>
> where RFacts.unit_notified_DTS >= {d '2006-05-15'}
>    and RFacts.unit_notified_DTS <= {d '2006-05-15'}
>
> or by using a date/time value:
>
> where RFacts.unit_notified_DTS >= {ts '2006-05-15 00:00:00'}
>    and RFacts.unit_notified_DTS <= {ts '2006-05-15 24:00:00'}
>
> Best regards,
> Boris Borzic
> -- 
> news://news.Xb2.NET
> http://www.Xb2.NET
> http://www.SQLExpress.net
> industrial strength Xbase++ development tools
>

Re: Large datasets

phil@pbih.net — Wed, 7 Jun 2006 23:24:05 +0100

Mahanimann,

> Phil Ide's suggestions of using DacPagedDataStore objects and/or "SELECT 
> .... LIMIT 10 OFFSET 10" looks cool, but that means in many ways a kind of 
> goodbye to straightforward, uncomplicated code.  Or does it?

Let me assure you, your code will become much simpler. As an example, I'll
use some code from my PGSql library, but the SqlExpress code would be very
similar:

  oDataSet := Sql( cSqlStatement,, Param1, Param2 )

  While !oDataSet:eof()
     // do something
     oDataSet:skip()
  Enddo


This is a typical structure for navigating a dataset. Compare that to a
typical DBF block:

   SEEK x

   While FIELD->V == x .and. FIELD->Y $ cMask .and.;
         FIELD->L < 5 .and. !Eof()
     // do something
      SKIP
   Enddo

The SQL code looks much cleaner - as far as you are concerned, the oDataSet
object *is your database* AND it will ALWAYS contain ONLY the records you
are interested in - if you craft your queries properly, so once you have the
dataset, no more filtering need be applied.

Regards,
-- 
Phil Ide

-------------------------------------------------------------
xbHCL (http://www.xbHCL.com) the xbase HTML command layer
PBIH  (http://pbih.eu)       Polar Bear International Hosting
-------------------------------------------------------------
Xbase++ FAQ, Libraries and Sources:
http://www.idep.org.uk/xbase

Do the words 'act of war' mean anything to you?

Re: Server Side Cursor and Browse

paaldalen@gmail.com — Sun, 1 Oct 2006 14:08:26 +0200

> be fast enough. Maybe we can develop such tool together with the help of 
> Boris.

I still think Phil Ide's idea about storing/caching browse pages like 
DacPagedDataStore() is a great idea.

But the very best solution would of course be to have a built-in, user 
changeable cache in SqlSelect().  I.e. something like 
oSqlSelectCursor:Cache( 100, 100 ) would cache 100 rows above-, and 100 rows 
beneath current row.

Boris, could this or something similar, be something for you to think about 
in future versions?

Regards,
Mahanimann

Re: Transaction tracking

tomaz.grom@siol.net — Wed, 7 Dec 2005 08:56:20 +0100

Thank you.

Re: SQLErrorHandler

stuart.fraser@cgi.com — Thu, 14 Dec 2006 10:58:03 -0800

Hi Boris,

Yes I had already tried this.

The problem is the SQLErrorHandler never gets called, when 
oConn:DisplayErrors := .f.

Which is why I asked about it.  :o)

I took your example from sqltest3.prg and plugged it into my app, but it 
gets the same result.  I also just simplified it down to give me some debug 
info, and it doesn't even do that, which tells me it's not being called.

Here is my simple "MySQLErrorHandler"

procedure MySQLErrorHandler( oOwner, cError, nRetCode, aErrObj )
   Local oConn
   msgbox("hello")

   dcqdebug valtype(oOwner)
   dcqdebug cError
   dcqdebug nRetCode
   dc_arrayview(aErrObj)
return

and it is called like so:

oConn:onError := { |oOwner,cError,nRetCode,aErrObj| ;
       MySQLErrorHandler(oOwner,@cError,@nRetCode,aErrObj), ;
       iif(nRetCode != SQL_SUCCESS_WITH_INFO, break(), nil)}

So any suggestions would be appreciated.

Stu.



"Boris Borzic" <ng-at-sqlexpress-dot-net> wrote in message 
news:Xns9899665065118SQLExpress@80.32.233.35...
> "Stu Fraser" <stuart.fraser@cgi.com> wrote in
> news:l0es3wnezp2xqcv.131220061954@ANDREA:
>
>> I notice if I set oConn:displayerrors:=.f. then SQLErrorHandler won't
>> create the log when something goes wrong.
>>
>> I am looking for a way to not display the ugly blue odbc error dialog
>> when an error occurs, but still be able to log for later analysis
>> anything that might have gone wrong.  Is there anyway to do this?
>
> You can do this by using your own SQLErrorHandler function. There is an
> example in SQLTEST3.PRG (see MySQLErrorHandler).
>
> Best regards,
> Boris Borzic
> -- 
> news://news.Xb2.NET
> http://www.Xb2.NET
> http://www.SQLExpress.net
> industrial strength Xbase++ development tools

SQL vs. Ace Wrappers

paaldalen@gmail.com — Sat, 20 May 2006 12:39:05 +0200

Another ADS question:

I'm trying out ADS (v7.0) on a remote server with the proprietary ADT table 
format. Using SQLExpress I understand that I have two ways to approach the 
server: Through ODBC using pure SQL and through the API via Ace Wrappers.

Could anyone please explain to me the pros and cons with the two approaches?

I have a Clipper only background and is a complete novice in both using SQL 
and client/server database. My only advantage in this that I have used Comix 
with compound indexes :-)

Thanks for *any* opinion and input.

Mahanimann

Re: fieldGet() question

rogerdonnay@donnay-software.com — Tue, 11 Oct 2005 14:58:56 -0600

Thanks Boris.

That saves me a lot of time .

"Boris Borzic" <ng-at-sqlexpress-dot-net> wrote in message
news:Xns96EC8CE00FA27SQLExpress@80.32.233.35...
> The problem occurs when you are using varchar fields. The DBMS will not
> pad a field with blanks. It will return exactly what was saved. You can
> pad the result in your browse by using a field's max width. Eg:
>
> SQLFieldBlock( oCursor, nField )
>    Local oCol, nLen, nDec
>
>    oCol := oCursor:getSQLColumn(nField)
>    nLen := oCol:length
>
>    if oCol:ValType == "C"
>       Return {|x|if(PCount()==0,PadR(oCursor:fieldGet(nField),nLen),;
>         oCursor:fieldPut(nField,Trim(x)))}
>    elseif oCol:ValType == "N"
>      nDec := oCol:decimals
>      Return {|x|if(PCount()==0,Str(oCursor:fieldGet(nField),nLen,nDec),;
>         oCursor:fieldPut(nField,val(x)))}
>    endif
>
>    Return {|x|if(PCount()==0,oCursor:fieldGet(nField),;
>     oCursor:fieldPut(nField,x))}
>
> Best regards,
> Boris Borzic
> -- 
> news://news.Xb2.NET
> http://www.Xb2.NET
> http://www.SQLExpress.net
> industrial strength Xbase++ development tools
>
>
> "Roger Donnay" <rogerdonnay@donnay-software.com> wrote in
> news:ma3p1uy527ydv4q.111020051714@ANDREA:
>
> > What is the prescribed method for creating a Get-Set codeblock for
> > editing a field?
> > I'm using the below function.
> > The problem is that :fieldGet() doesn't pad the value to the maximum
> > length of the field.
> > This is needed when creating a screen of Gets.
> > I know that I could probably build a table with this information but I
> > was hoping there is a simpler answer.
> >
> > FUNCTION SQLFieldBlock( oCursor, nField )
> >
> > Return {|x| iif(PCount()==0, ;
> >             oCursor:fieldGet(nField), ;
> >             oCursor:fieldPut(nField, x))}
>

Re: SQLListTables fails at the scond call

ng-at-sqlexpress-dot-net@ — Fri, 24 Mar 2006 15:42:13 +0100

"Reinthaler Rudolf" <office@c-tec.at> wrote in
news:y2iwqus4ci6wfep.240320061100@ANDREA: 

> I have a strange effect when calling SQLListTables in a MY SQL
> Database. The first time it works, but if I call it the second time, I
> get no tables back. Any idea ?

It works OK on my system when I run the sample SQLBRO connecting to MS 
Access or SQL Server.

I would suggest modifying SQLBRO to connect to your DBMS and see if it 
works. If it does, then you have a problem in your code somewhere. If it 
does not work, then there is a bug in the MySQL ODBC driver.

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: New customer

tomaz.grom@siol.net — Fri, 25 Nov 2005 20:05:53 +0100

I only hope, that it won't demand to much time and headache when making dual 
approach in my huge code.

Now I am solving the problem of remote acces at few places with remote 
desktop (dedicated machine) in the firm an mostly the director has access 
from its home to the office. So, only the screen and keyboard/mouse 
informations go through the line, nothing else. NetOp is the king for that. 
Microsoft tools are not so good (quick).

But I wander, if my program would be good C/S designed, would it be better 
even in such cases, where dedicated machines are available, to run 
application rather at home computer and have only access throuhg the IP to 
the office server database (line is ADSL 2048/386 Kb/s), or screen transfer 
would remain even then the better choice? Namely in remote desktop approach 
LAN is quick (100MB/1GB), only back (to home) printing is slow.

One more thing.
If I remain on FOXCDX format running on ADS, would you reccomend (is it 
possible) to make referential integritiy keys. Now I use UNIQUE keys for 
that purpose to identify the presence of the code in transaction table to 
prevent the deletion in catalog.

Any suggestion form practice ?

Best regards
  Toma

"Boris Borzic" <ng-at-sqlexpress-dot-net> je napisal v sporoilo 
news:Xns97196BF6F2614SQLExpress@80.32.233.35 ...
> "Toma Grom" <tomaz.grom@siol.net> wrote in
> news:hmuulnn5ss8bt8g.251120051125@ANDREA:
>
>> I have just paid SQLExpress Pro.
>> New era seems to begin for me    :-).
>
> Thank you for the order and welcome to the 21st century <g>
>
> I'm sure you will find that SQL requires a small paradigm shift.
>
> Best regards,
> Boris Borzic
> -- 
> news://news.Xb2.NET
> http://www.Xb2.NET
> http://www.SQLExpress.net
> industrial strength Xbase++ development tools

Re: EXCEL cells without header

ng-at-sqlexpress-dot-net@ — Tue, 24 Jan 2006 15:58:22 +0100

"Reinthaler Rudolf" <office@c-tec.at> wrote in
news:58fxos54fbf8qc2.240120060937@ANDREA: 

> I have to write to a EXCEL Sheet without headers in the columns. How
> can I address this cells without the name of the cell ?

oCur:=oConn:Cursor('SELECT * FROM `Test$A2:Z10`')
oCur:Execute()
? oCur:FieldGet(1), oCur:FieldGet(2),....

> Another question is, how can I creat a new XLS file with a table  ?

see sqlexcel.prg

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: New customer

ng-at-sqlexpress-dot-net@ — Fri, 25 Nov 2005 16:38:52 +0100

"Toma Grom" <tomaz.grom@siol.net> wrote in 
news:hmuulnn5ss8bt8g.251120051125@ANDREA:

> I have just paid SQLExpress Pro.
> New era seems to begin for me    :-).

Thank you for the order and welcome to the 21st century <g>

I'm sure you will find that SQL requires a small paradigm shift.

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

MySQL

office@c-tec.at — Thu, 19 Jan 2006 14:50:05 +0100

Hello,
does anyone know how to start with MySQL after the installation ? I have 
also installed MySQLAdministrator and created a connection with username and 
password, Hostname localhost. In ODBC I have defined a User DSN with Server 
localhost, Username and password. When testing, I get a errormessage
 [MySQL][ODBC 3.51 Driver]Access denied for user 'ctec'@'localhost' (using 
password: YES)

regards
Rudolf

Re: SQLExpress objects crash VXB debugger

ng-at-sqlexpress-dot-net@ — Thu, 15 Jun 2006 15:39:20 +0200

"Mahanimann" <paaldalen@gmail.com> wrote in
news:mw7kcbzjckzcrti.150620061437@ANDREA: 

> Now I've upgraded to v1.90.331 and SQLExpress v...24.  VXB still
> crashes, XppDbg.exe is better, but freezes randomly in the same way.
> Any suggestions? Which debugger do you use successfully?

Actually, I don't use the debugger. I write my own debug code that is 
enabled by the pre-processor when compiling with a debug define. The debug 
output is simply routed to a separate CRT window and logged to a file.

First, I would make sure that I don't have any DLL version mis-matches. If 
I'm 100% sure that everything is up-to-date and the problem is still there, 
then I would report the problem to Alaska Software.

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: How to do a browse (no kidding)

jwrl@charter.net — Wed, 20 Dec 2006 12:05:19 -0500

As an aside note you should not use SELECT *

Specify only the fields (columns) needed for the browse. This can speed
things up a lot since only the required fields are moved across the network.

Jim

Mahanimann wrote:
> Hi,
> 
> Have a look at the thread "Large datasets" which is a discussion on your 
> topic.  I think the conclusion is summarized to Boris' reply....
> 
>> If you really need to browse such a large result set, the
>> solution is to use SQLSelect with either a dynamic or keyset driven cursor.
>>
>> However, I do not recomend browsing such a large result set. I suggest that
>> you redesign the UI and browse data in smaller chunks.
> 
> ... or Phil Ide's idea....
> 
>> If I had time, I'd knock up an SqlDacPagedDataStore for use with 
>> SqlExpress,
>> because I think that would prove a very useful tool to a great many people.
>> Unfortunately I am so busy at the moment that I can't really say for 
>> certain
>> when I'd be able to get around to it.
>>
>> When I get some free time, and if no-one has beaten me to it, I'll 
>> certainly
>> have a go.
> 
> ...I quite agree that this would be a VERY usefull too to a great many 
> people.  A little later Phil wrote...
> 
>> Ok, I've written one :-)
>>
>> Don't get excited just yet, it'll need a bit of testing and debugging, but
>> it was (generally) much simpler than I thought, knocking in at around 240
>> lines of code. I have to add the methods scrollUp, scrollDown and scrollTo,
>> but won't do that until the rest of it is working.
>>
>> When I get my next free 10 minutes, I'll start debugging it :-)
> 
> I don't think he has had the time for that yet.  I have posted a couple of 
> reminders for him... (Phil, are you there?)
> 
> Anyways, I started with Xbase this summer and have not yet any good idea on 
> how to handle large cursors.  With "large cursors" in this context I presume 
> we are using SqlSelect (serverside) cursors.
> 
> Because of time preassure I have not had the time to experiment much, so 
> until I get a better idea from here/by myself I use a " 'Fetch previous/next 
> XX records'-buttons"-solution.  Searching goes through a temporary 
> search/lookup-cursor from where I get a unique key (:aPrimaryKey) which I 
> then search for in the primary cursor. If it's not there, I change the 
> oCurs:SqlString accordingly and do a oCurs:Refresh().  Cumbersome, but the 
> best I have had the time to come up with so far.
> 
> I have not yet implemented this solution into my app yet (at the moment I 
> retrieve all rows, not subsets), but I've tested it and it works pretty 
> fast.  What I have implemented as a result from this testing is sorting 
> SqlSelect cursors in browses.  When the user clicks on a browse heading the 
> cursor gets sorted by that column by changing the oCurs:SqlString as 
> mentioned above (in this case the only change in the :SqlString is the "... 
> ORDER BY ..." part).
> 
> I also have a generic browse function and all calls to SqlDataSet/SqlSelect 
> goes through one semi-generic function.  This makes it a snap to change any 
> behaviour for the whole app.
> 
>> It is possible to limit the dataset, but how do I deal with the scrolling
>> up/scrolling down?
> 
> Yes, this is why I have not implemented it yet.  When scrolling in my (test) 
> browse and you reach oCurs:Bof()/Eof() you have to push either the "Fetch 
> next XX records" button or the "Fetch previous XX records" button.  When I 
> get the time I will make this fetching automatic.  This will give the user 
> the impression of scrolling through a full cursor, not just a subset of a 
> couple of houndred rows.  I think I sat the subset limit to 200 
> rows/records, and that works very fast in my test environment which (in a 
> separate test) also included a 10 m/bit network.
> 
> I hope many people give their oppinion on this!
> 
> Best regards,
> Mahanimann
> 
>

Re: SQLDataSet:Sort()

ng-at-sqlexpress-dot-net@ — Wed, 15 Feb 2006 20:32:32 +0100

"Stu Fraser" <stuart-fraser@shaw.ca> wrote in 
news:2g0nd8scswqsqfb.150220061900@ANDREA:

> So.... Any other suggestions?

It works fine in my small test program. Can you try doing the sorting 
outside of your browser and displaying the results in a DOS window, eg:

   oCursor:gobottom()
   oCursor:sort("somefield", .t.)
   oCursor:gotop()
   ? "sorted ascending...."
   while ! oCursor:eof
      ? oCursor:FieldGet("somefield")
      oCursor:skip()
   end

   oCursor:sort("somefield", .f.)
   oCursor:gotop()
   ? "sorted decending...."
   while ! oCursor:eof
      ? oCursor:FieldGet("somefield")
      oCursor:skip()
   end


Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

SQLExpress, ADS and deleted records

tomaz.grom@siol.net — Mon, 30 Oct 2006 09:46:42 +0100

Boris,

maybe you know what happens, when xBase programmer hide deleted records 
inside .DBF table with command SET DELETED OFF and then with an SQL 
statement request data from the .DBF table.
Are deleted records hidden or not, I mean, does the cursor (result set) 
brings back only desired data, or mixture of deleted and undeleted records ?

Best regards

Toma

Re: sqlexpress and seek

placek@opava.cz — Thu, 20 Apr 2006 19:35:10 +0200

o.k, but I'm using only local server mssql.
And I would like to use "order by".
In my database I set the correct collation, so in this table and this 
char row. Exist any other setting ?

thanks, placek


Boris Borzic napsal(a):
> placek <placek@opava.cz> wrote in news:zff54og4wpcnfwx.200420061750@ANDREA:
> 
>> Please, what is the difference between
>> sql command "Select ... Order By ..."  and :Sort() method ?
> 
> :sort() does the sorting on the client (in your app), "ORDER BY" does it on 
> the server side (by the DBMS). Because of differences in collation 
> sequences between the server and the client, the results can be different.
> 
> Best regards,
> Boris Borzic

Re: problems when read blob fields with images from dbms

ng-at-sqlexpress-dot-net@ — Mon, 4 Jun 2007 14:01:30 +0200

"giuseppe" <airsoft1@tin.it> wrote in
news:0os51cdtoye8hch.030620071939@VDS-472773: 

> I use Mysql v. 4.1.14 and sqlexepres 3.0.03
> I save pictures into a Longblob field with the command 
> 'field=load_file(<file_name>)'.
> when I read the field with the images from dbms and save it on the
> disk, the size of the images is changed and I can't. read it
> (photoshop,jpg viewer etc.).
> The same operation with MysqlQueryBrowser works fine.(so I think that
> isn't a problem of database)

It may be a problem of the ODBC driver. Please try the same operation with 
another DBMS (e. MS SQLServer if available) and also try it with another 
ODBC driver.

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Attacher a un fichier en rseau

thomas_reynald@msn.com — Thu, 9 Feb 2006 10:33:02 +0100

Bonjour,

je voudrais utiliser un fichier .mdf sis sur un repertoire en rseau.
L'interface de management de SQLExpress ne me permet que de choisir un 
fichiers sur mon disque C.
Par Script, si je met, par exemple \\monServer\Echange\database.mdf

ca ne fonctionne pas (fonctionne avec un fichier local)

Merci

Renfield
MVP Visual Basic

Error in fieldget()

ramirezosvaldo@prodigy.net.mx — Mon, 20 Nov 2006 19:40:25 -0700

Hello guys

I have this

    cString := "SELECT * FROM "+_main_alias +" where cli_id = 
"+alltrim(str(oCursor:fieldget("cli_id")))+";"
    oStmt   := SQLSelect():new( cString , oConnection )

if I put this :

      m->cli_id   := oStmt:fieldget("CLI_ID")
      m->cli_nom  := oStmt:fieldget("cli_nom")
      m->cli_dir  := oStmt:fieldget("cli_dir")
      m->cli_tel1 := oStmt:fieldget("cli_tel1")

I have an error in fieldget()

But If I put this

    if oStmt:reccount() > 0

then this :

      m->cli_id   := oStmt:fieldget("CLI_ID")
      m->cli_nom  := oStmt:fieldget("cli_nom")
      m->cli_dir  := oStmt:fieldget("cli_dir")
      m->cli_tel1 := oStmt:fieldget("cli_tel1")

All work fine.

Any hints ?

Best Regars
Osvaldo Ramirez


Sorry If I have or ask some erroneous thing

P.S. I attach the xpperror.log

Re: Microsoft ODBC for Oracle and Win XP

ng-at-sqlexpress-dot-net@ — Tue, 6 Jun 2006 21:47:55 +0200

Boris Borzic <ng-at-sqlexpress-dot-net> wrote in 
news:Xns97DAA05B653BESQLExpress@80.32.233.35:

> You can't pass that as a param. It's an ODBC escape sequence that is 
> replaced by the ODBC driver with a proper date or time.

you can also try this:

where RFacts.unit_notified_DTS >= ?}
    and RFacts.unit_notified_DTS <= ?}

oCursor:Execute( {date(), date()} )

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: Incremetal search

ng-at-sqlexpress-dot-net@ — Mon, 27 Feb 2006 14:47:28 +0100

"Ismail YALCIN" <iyalcin@3cbilyaz.com> wrote in 
news:3pfz2f17d41bap8.270220061126@ANDREA:

> can i change cursor rule
> oCursor:=oConn:Corsor("Select * from customer Where user="test")
> .
> .
> after thant i want to change curser rule
> oCursor:=oConn:Corsor("Select * from customer Where user="learn")
> Can I without destroying first cursor or any other way ..

oCursor:=oConn:Cursor("Select * from customer Where user=?)
oCursor:execute("test")
? oCursor:FieldGet(1),...
? oCursor:skip()
// etc...

oCursor:execute("learn")
? oCursor:FieldGet(1),...
? oCursor:skip()
// etc...


> Which  is method is  useful for connection type

If you are executing many SQL statements it's best to keep the connection 
open until you terminate your app. Have a look at MyDefaultSQLConnection() 
in SQLTEST3.PRG 


Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: ORA-01445 Error

stuart.fraser@cgi.com — Tue, 5 Jun 2007 09:06:46 -0700

Hi Boris,

yes that succeeds and does not create the log.  I suspected the same, 
however I need more functionality with the cursor than the FORWARD_ONLY 
gives me.  i.e. I need to be able to present this in a browse that can be 
scrolled up and down and I need to do a locate within that browse at times 
as well.

Stu.

"Boris Borzic" <ng-at-sqlexpress-dot-net> wrote in message 
news:Xns994679E4A60CSQLExpress@62.193.212.32...
> "Stu Fraser" <stuart.fraser@cgi.com> wrote in
> news:p1kga0dtbkued44.050620071744@VDS-472773:
>
>> I have a query running against an Oracle View.  When it does run it
>> actually succeeds, however I get an sqlerror.log created as well with
>> the following information:
>
> Can you try running the query using a SQL_CURSOR_FORWARD_ONLY cursor
> instead of a keyset driven cursor.
>
> Best regards,
> Boris Borzic
> -- 
> news://news.Xb2.NET
> http://www.Xb2.NET
> http://www.SQLExpress.net
> industrial strength Xbase++ development tools

Re: MYSQL Connection to Webserver

office@c-tec.at — Tue, 17 Jan 2006 18:15:45 +0100

Hello Boris,
thank you, I forgot that my provider has a special prefix for the databases, 
now it works perfect.
But I still cannot create a local DSN for MySQL. Also I have no idea how to 
create a database without SQL commands.
regards
Rudolf


"Boris Borzic" <ng-at-sqlexpress-dot-net> schrieb im Newsbeitrag 
news:Xns974E6D48B78EBSQLExpress@80.32.233.35...
> "Reinthaler Rudolf" <office@c-tec.at> wrote in
> news:rpweh4qghxwwyef.170120061625@ANDREA:
>
>> I have downloades MySQL Administrator and can now connect to my SQL
>> Database on the server via server webaddress and port. So I think it
>> must also be possible with SQLEXPRESS. But how ?
>
> Have you tried creating a DSN?
>
> http://dev.mysql.com/doc/refman/5.0/en/dsn-on-windows.html
>
> Best regards,
> Boris Borzic
> -- 
> news://news.Xb2.NET
> http://www.Xb2.NET
> http://www.SQLExpress.net
> industrial strength Xbase++ development tools

Re: sql null statement

jax_only@news.nmsc.gov — Wed, 8 Mar 2006 15:54:18 -0500

I actually wrote the wrong thing, the error is:

= SQL ERROR ===========
Date: 20060308 14:00:35
C:\iFolder\projects\web\v2\main.exe, Thread: 7
Windows XP 05.01 Build 02600 Service Pack 2, SQLXpp: 3.1.23, Runtime: 
1.90.326
NULL STMT handle

Thread ID 7
Called from SQLSTATEMENT:EXECUTE(450)
Called from SQLSELECT:EXECUTE(1574)
Called from SQLSELECT:REFRESH(1026)
Called from SQLSELECT:RECCOUNT(3047)
Called from USER_LOGIN(40)
Called from WEB_DISP(36)
Called from HTTPHANDLER(35)
Called from (B)SW_SERVER(88)
Called from XBHTTPTHREAD:EXECUTE(4074)

SQLString: SELECT FULL_NAME, USERCODE, COMPANY_NO, AGENCY_NO, CLEARENCES, 
REC_ORIG FROM USERS





"Boris Borzic" <ng-at-sqlexpress-dot-net> wrote in message 
news:Xns978088643FEFSQLExpress@80.32.233.35...
> "Erik" <edimail3@nmsc.gov> wrote in
> news:no1makl8zg53vpq.080320061542@ANDREA:
>
>> I sometimes get the error "sql null statement" when I execute a simple
>> select statement against a ADS(dictionary) ODBC database.  The strange
>> thing is that sometimes it returns the correct result, most of the
>> time it logs the "sql null statement" error ?
>>
>> ODBC is kind of new to me, any ideas how to resolve this kind of
>> error?
>
> I have not seen this particular error before. Suggest you post the 
> question
> on the ADS NG: news://devzone.advantagedatabase.com
>
> You may want to give them more info like the actual statement and error
> code numbers.
>
> Best regards,
> Boris Borzic
> -- 
> news://news.Xb2.NET
> http://www.Xb2.NET
> http://www.SQLExpress.net
> industrial strength Xbase++ development tools

Re: Installer

ng-at-sqlexpress-dot-net@ — Thu, 26 Oct 2006 22:54:00 +0200

Osvaldo Ramirez <ramirezosvaldo@prodigy.net.mx> wrote in 
news:6spwvo6tbtu57by.261020061633@ANDREA:

> The next week I will "distribuite" my first app that use sql, ( it is 
> very small ), it use only 2 tables, so I want to make a setup with inno 
> setup, so, I want to inlclude the ODBC of mysql in that install.
> I think that the odbc is an dll and some additional files, but how to 
> know where is what are ?

hope this helps:
http://dev.mysql.com/doc/refman/5.0/en/myodbc-installation-binary.html

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: check if ODBC driver is installed

ng-at-sqlexpress-dot-net@ — Mon, 27 Mar 2006 15:16:19 +0200

"Reinthaler Rudolf" <office@c-tec.at> wrote in
news:1vwrcnk1wmzmgse.270320061207@ANDREA: 

> when no ODBC driver is insalled or wrong configured, the application
> quits when connecting without any message. How can I check if the
> driver is correct installed to prevent this problem ?

The app should not terminate. The :connect() method should return .F. and 
an error log should be generated.

> How can I make a install programm for installing MYSQL, the ODBC
> driver and configuration of all ?

Some install programs will do this for you.

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: PostgreSQL connection

phil@pbih.net — Mon, 21 Aug 2006 14:55:03 +0100

Leandro,

> Thanks for your response, but I'm wonder if with SQLExpress or with XbPgSQL 
> classes, I can work the way I do in xbase++ with workareas, relations, 
> filters, copy to, dbcreate(), fields inline assigment ( (nArea )->field := 
> xSomeValue), dbseek(), dbdelete(), dbcommit(), and the most important to me 
> dbsetscope().

To do this, you'll need to use Alaska's ODBCDBE, which interfaces with ODBC
at one end, and the DBML (database manipulation layer - the command/function
interface which supports COMMIT, SEEK etc.).


> It could be good If you can show me some examples. And finally excuse my 
> poor SQL knowledge (I'm reading), but what do you mean with "the right type 
> of cursor"?

Well, when dealing with SQL, you request the data you want to examine. For
example, the fetch all customers who live in Holland, you might do this:

  SELECT * from customers where country='NL';

This will return a set of records containing only the matching records. You
cannot see any other records.  You can set the order of the returned records
too:

  SELECT * from customers where country='NL' order by country;

When you fetch the entire database (table), you also fetch a set which just
happenss to contain all records:

  SELECT * from customers;

A cursor is like a record pointer - it points to a particular record within
a particular record set. Cursors are important, because they operate in
different modes. These allow you to fetch all the data in the set to your
application at once, or fetch individual records on demand. They can also be
sensitive to or ignore any updates to records since you sent the initial
request to fetch the data.

Regards,
-- 
Phil Ide

-----------------------------------------------------------------
xbHCL (http://www.xbHCL.com)     Xbase++ HTML command layer
PBIH  (http://www.pbih.eu)       Polar Bear International Hosting
-----------------------------------------------------------------
Xbase++ FAQ, Libraries and Sources:
http://www.idep.org.uk/xbase

Shakka, when the walls fell

Re: ORA-01445 Error

stuart.fraser@cgi.com — Tue, 5 Jun 2007 14:20:52 -0700

Yes I use Data Sets where ever possible when I need a scroll-able cursor, 
however in this particular case the user is defining the parameters for the 
query and so could theoretically request 500,000 rows which will take a very 
long time on a data set.

Since this has been in production for some time, and it doesn't crash the 
app, and it does return the rows anyway I'm going to leave it as is I think.

thanks for the input,

Stu.

"Boris Borzic" <ng-at-sqlexpress-dot-net> wrote in message 
news:Xns99469C3827C49SQLExpress@62.193.212.32...
> "Stu Fraser" <stuart.fraser@cgi.com> wrote in
> news:0dl2jmnvxaghi0j.050620071836@VDS-472773:
>
>> I just noticed this in the docs for read only concurrancy.
>>
>> "Although this is a read-only cursor, updates to the underlying table
>> may still be performed using the :FieldPut() and :Delete() methods
>> since SQLExpress will generate a searched UPDATE or DELETE statement
>> to apply the changes. "
>>
>> So I'm guessing you are requesting a ROW ID in there?  Is there any
>> way with SQL Express to make a scrollable cursor that doesn't request
>> a ROW ID ?
>
> No, I'm not requesting any additional fields. I suspect the Oracle ODBC
> driver is doing that.
>
> If you need a scrollable cursor, I suggest you use SQLDataSet.
>
> Best regards,
> Boris Borzic
> -- 
> news://news.Xb2.NET
> http://www.Xb2.NET
> http://www.SQLExpress.net
> industrial strength Xbase++ development tools
>

Re: Oracle ODBC Error

ng-at-sqlexpress-dot-net@ — Thu, 5 Oct 2006 20:43:01 +0200

"Stu Fraser" <stuart.fraser@cgi.com> wrote in
news:owsdtnmqsvwfne2.051020061903@ANDREA: 

> In this particular instance I am creating an SQLDataSet.   The Docs
> mention: 
> 
> When instantiated, this class will open the fastest and least
> expensive (read-only, forward) server-side cursor
> 
> I am just using an SQL Statement when creating this.
> 
> oCursor  := SQLDataSet():new(cStatement, oConnection, ,,,,,.t.,.t.)
> 
> Can I assume this is read only and not the cause of the problem?

Yes, this will create a read-only cursor. It is not the cause of your ROWID 
problem.

Have you tried another version of the ODBC driver?

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: Error in fieldget()

ng-at-sqlexpress-dot-net@ — Wed, 22 Nov 2006 15:35:41 +0100

Osvaldo Ramirez <ramirezosvaldo@prodigy.net.mx> wrote in 
news:nd57hplsroccalh.221120060622@ANDREA:

> The thing is, this number is the key of the relation of other tables
> For example: an Invoice has a client number and this client number is 
> the key to relation to the client table, so if I put this as 
> auto-incremental number, what happend If I delete some record and add a 
> new record, ? Could be the same number ?

No. An auto-incrementing field will always give you a new number when you 
insert a new row.

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: SEEK and you won't find

ng-at-sqlexpress-dot-net@ — Fri, 7 Apr 2006 15:08:56 +0200

"Ernie Barlow" <emailme@work.com> wrote in 
news:t5ipybmec6jla5w.070420061021@ANDREA:

> PS.  Is : Seek() with a DESC  ordered dataset a possibility in a future
> release?

Yes, it is a possibility... although you are the first person to ask for 
this.

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: :Recno() alternative?

jwrl@charter.net — Sat, 09 Sep 2006 13:34:21 -0400

Well you could just open a new cursor do what is needed there and your
original has never left the base row. Just go back to the original cursor.

Jim







Mahanimann wrote:
>> In SQL you don't need an index you can request sets of records in any
>> order with any filter. Having an index speeds things up. Generally
> 
> Yes I know. I must have expressed myself wrongly.
> 
> What I mean is when you f.ex. use a generic sort-function, you need to 
> :GoTo(nTheActiveRecnoBeforeTheSort) after the sort.  But, the :Recno() 
> numbering change with the sort order, so one can't use :GoTo(). When you 
> can't use :GoTo(), you need another unique value to seek on.  When the 
> environment is generic, you need to know where to find that unique value 
> within the oCursor.
> 
> That's where my question about :aPrimaryKey comes in.  If I could access 
> oCursor:aPrimarKey in the generic sort-function, my "problem" is solved. Of 
> course it is simple to overcome this, but why code extra for something that 
> is allready there.  I do define :aPrimaryKey in all cursors.
> 
> That is one part of my question, oCursor:aPrimaryKey is there, so why not 
> use it? (and why not give access to it?)
> 
> The other part is:  How do seasoned SqlExpress'ers handles situations where 
> they need to go back to a specific row/record (after f.ex. a change in a 
> browse sort order).  The function is generic, so it has no clue about which 
> table it is sorting.  The sort-function only recives oCursor as a parameter.
> 
> I'll be more specific in my phrasing from now on :-)
> 
> Thanks for any reply,
> Mahanimann 
> 
>

Ann: SQLExpress 3.1.23 released

ng-at-sqlexpress-dot-net@ — Fri, 6 Jan 2006 21:21:37 +0100

SQLExpress ver 3.1.23 has been released this week.

This upgrade is provided FREE of charge to all current SQLExpress
subscribers. If you are a registered user, you should have already 
received email notification of the new build; including download and 
installation instructions. 

If you are not a registered SQLExpress user, then please follow the 
hyperlinks below. When you purchase SQLExpress, you will receive one 
full year of free technical support and software updates.

Click here to:

   * Place an order:
     http://sqlexpress.net/register.htm

   * Get a demo:
     mailto:demo@sqlexpress.net?subject=sqlexpress_demo

   * Learn more about SQLExpress:
     http://sqlexpress.net

                            --- * ---

SQLExpress is an object-oriented ODBC library that provides your
Xbase++ application with seamless connectivity to many RDBMS and
ISAM databases. With SQLExpress you will be able to create
industrial strength client/server applications using databases such
as Advantage Database, MS-SQL Server, MySQL, Oracle, DB2, Sybase, 
PgSQL and many others. SQLExpress may also be used with many 
flat-file databases, such as MS-Access, dBase, Paradox and Btrieve.

If you are building mission critical database applications, then
you need SQLExpress!

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: Error in fieldget()

ng-at-sqlexpress-dot-net@ — Tue, 21 Nov 2006 23:30:51 +0100

Osvaldo Ramirez <ramirezosvaldo@prodigy.net.mx> wrote in 
news:fyl6qbkicwvtj25.211120062006@ANDREA:

> Boris, actualy I have a dbf called control, where I store all 
> consecutive number of my others dbf, like invoice, cuotation, 
> clients,etc,etc. So, when I save an Invoice, I add one number to my 
> control table and get this number to save on my new invoices record.
> 
> So I want to ask, if this kind of procedure is ok, I mean put a sql 
> table like control, to save all consecutive number ?

You can do it that way, but I prefer to simply add an auto-incramenting 
field to the target tables. For example when you insert a new row to the 
invoice table, the DBMS will automatically generate a new invoice number 
(one less step).

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Large datasets - Phil?

paaldalen@gmail.com — Sat, 9 Sep 2006 05:09:59 +0200

Hi there Phil,

This is cut out from the the thread "Large datasets" from the beginning of 
june:
*******************************************************
*******************************************************
Jimmy,

> When you get the time I would greatly appreciate if you would create an
> SqlDacPagedDataStore. As you say it
> would be a great tool to have.

Ok, I've written one :-)

Don't get excited just yet, it'll need a bit of testing and debugging, but
it was (generally) much simpler than I thought, knocking in at around 240
lines of code. I have to add the methods scrollUp, scrollDown and scrollTo,
but won't do that until the rest of it is working.

When I get my next free 10 minutes, I'll start debugging it :-)

Regards,
-- 
Phil Ide
*******************************************************
*******************************************************

Have you had any progress with this?  Any other ideas on the matter?
I sure am interested if you have:-)

Regards,
Mahanimann

SubIndexes

tsnyder@compusolutions.com — Tue, 25 Oct 2005 22:19:51 -0400

Boris,

We are trying to create subindexes on the fly in Xbase++/Advantage as we did
in Clippper

INDEX ON Name FOR left(NAME,2)="CA" TO MyIndex SUBINDEX

We can use the AddKey() method, but that is very slow. The SUBINDEX method
in Clipper is much faster.

We looked at the ace wrappers, but didn't see how we might accomplish this.

Any help would be appreciated.
Thanks,
Tim

Re: Installer

ramirezosvaldo@prodigy.net.mx — Mon, 15 Jan 2007 16:31:13 -0700

Dear Boris Borzic

This is my function


FUNCTION InstalarMySQLODBC()
* Begin
   LOCAL cKey , oReg , lInstalled := .F. , cDirMySQL := 
"\download\MySQL-Install\" , cTarjet := "\windows\system32\"
   cKey := "HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\MySQL ODBC 
3.51 Driver"
   oReg := XbpReg():NEW( cKey )
   lInstalled := oReg:Status()
   oReg := NIL
   IF ! lInstalled
     if f_yesno({"Los drives de MySQL ODBC, no estan instalados","Desea 
instalarlos ?","","Recuerde tener el folder de MySQL ["+cDirMySQL+"]"})
       copyfile( cDirMySQL +"\lib\msvcr71.dll" , cTarjet +"msvcr71.dll" )
       copyfile( cDirMySQL +"\lib\myodbc3S.dll" , cTarjet +"myodbc3S.dll")
       copyfile( cDirMySQL +"\lib\myodbc3S.lib" , cTarjet +"myodbc3S.lib")
       copyfile( cDirMySQL +"\lib\myodbc3.dll"  , cTarjet +"myodbc3.dll" )
       copyfile( cDirMySQL +"\lib\myodbc3.lib"  , cTarjet +"myodbc3.lib" )
       copyfile( cDirMySQL +"\bin\myodbc3i.exe" , cTarjet +"myodbc3i.exe")
       copyfile( cDirMySQL +"\bin\myodbc3m.exe" , cTarjet +"myodbc3m.exe")
       copyfile( cDirMySQL +"\bin\myodbc3c.exe" , cTarjet +"myodbc3c.exe")
       if file(cTarjet+'myodbc3i.exe')
         runshell('-a -d -t"MySQL ODBC 3.51 
Driver;DRIVER=myodbc3.dll;SETUP=myodbc3S.dll',cTarjet+'myodbc3i.exe')
         linstalled := .T.
       else
         msgbox("No se pueden instalar los drivers de MySQL 
ODBC"+"-"+"El archivo myodbc3i.exe, no existe"})
       endif
     endif
   endif
RETURN  lInstalled

HTH
Osvaldo Ramirez

statement handle problem

edimail3@news.nmsc.gov — Fri, 23 Feb 2007 14:10:48 -0500

I have a SQLExpress & xb2.net application that seems to be leaking memory. 
I am currently looking at the xbsession():SaveSessions(), it can be 50+mb 
depending on how long the application is running.  I am also finding that 
the oConn:ActiveStatements() seems to be climbing with every few hits on 
that thread.

Is there any way to see what statements are currently active for each 
connection?

Thanks,

Erik

Re: Memo Field

fst-procurement@telkomsa.net — Tue, 14 Nov 2006 11:35:30 +0200

Hi Boris

Any news on this problem?

regards

jimmy

"Boris Borzic" <ng-at-sqlexpress-dot-net> wrote in message
news:Xns9870EC12B5988SQLExpress@80.32.233.35...
> "Jimmy Malan" <fst-procurement@telkomsa.net> wrote in
> news:s8n5nyk5zn5bv6o.031120060721@ANDREA:
>
> > I tried to insert a memo field into a table with a field type of
> > Char(2048). No data was inserted and no error was raised..
> >
> > I then assigned the memo field to a local variable with the same
> > result.
> >
> > I then assigned the memo field to a local variable using Alltrim()
> > which seemed to do the trick.
> >
> > Is this the correct method to use ? Is there baggage in a memo field
> > that Sql does not like ?
>
> I think the problem is in SQLExpress. It's looking for a varchar of "C"
and
> not "M". Since memo fields retain the "M" type even after being assigned
to
> a memvar, SQLExpress will not process this data properly.
>
> I will send you an updated DLL by email in the next day or so for you to
> test.
>
> Best regards,
> Boris Borzic
> -- 
> news://news.Xb2.NET
> http://www.Xb2.NET
> http://www.SQLExpress.net
> industrial strength Xbase++ development tools

Re: Select inside select

ng-at-sqlexpress-dot-net@ — Sat, 17 Feb 2007 14:44:12 +0100

Osvaldo Ramirez <ramirezosvaldo@prodigy.net.mx> wrote in 
news:kegyuvbyfgjsmha.170220070130@ANDREA:

> Tell me, inner Join is more fast that have two cursor with a relation ?

inner join will be faster

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

SQLConnection question

vjharris@starband.net — Fri, 21 Apr 2006 11:33:13 -0500

oConn := SQLConnection():new('MyNewDSN', 'MyUserId', 'MyPassword')

After installing MSDE I create an SQL database:
setup SAPWD="byteme98"  INSTANCENAME="EDUSTRUCTURES" SECURITYMODE=SQL 
DISABLENETWORKPROTOCOLS=0

My computer where the SQL Server is running is JeanLapTop

Now I want to Creat an SQL ODBC Data Source Connection. So I do Start menu, 
point to Settings | Control Panel | Administrative Tools and Select ODBC 
Data Sources. I select the System DSN tabpage then press
1 ADD.
2 Then I select SQL Server..
3 then I enter LunchCashierSIF for the name and the Descriptions and
4 I select JEANLAPTOP\EDUSTRUCTURES as the server.
5 I then change the defaut database to LunchCashierSIF

What do I put into these parameters to have the SQLConnection:new work 
correctly?
MyNewDSN
MyUserId
MyPassword

Jean Harris

Re: What BIT values to use in oStmt?

ng-at-sqlexpress-dot-net@ — Tue, 26 Dec 2006 15:17:31 +0100

"Mahanimann" <paaldalen@gmail.com> wrote in
news:3h5wa5zm2k3hwnv.251220061419@ANDREA: 

>I use the SQL BIT type for logical fields.  This works fine with 
>:FieldGet()/:FieldPut(), but what SqlExpress compatible values do I use
>in SQL statements?
> 
> Example: "UPDATE Customers SET lActive=1" does update the table, but
> when retrieving with oCustCurs:FieldGet("lActive") I allways get .F.
> (I've tried with several different parameters, including SET lActive =
> b'1') 

what does the DBMS return for this column when you execute a SELECT using 
the DBMS's query tools?

Don't know if this will work, but try setting the BIT column to "T"/"F", 
eg: UPDATE Customers SET lActive='T'

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Pass data to local II.

ccalvoc@telefonica.net — Tue, 15 May 2007 22:32:14 +0200

I have had any problems and I dont know what is happening.
It says XPPFATAL.
I attach source and logs.
Thansk.

Re: Large datasets

ng-at-sqlexpress-dot-net@ — Thu, 8 Jun 2006 15:50:07 +0200

"Mahanimann" <paaldalen@gmail.com> wrote in
news:8ipl6qmnhk1qteu.070620062150@ANDREA: 

> The table in question contains items sold in a shop, and I need to
> search for item text, ID, who sold this, date, time etc.  With
> "redesign the UI", do you suggest that the user must give the search
> info _before_ we do the SELECT command?  No
> "list-all-rows-then-start-filtering" like in Clipper, but the
> opposite? 

Yes exactly.

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Re: little problem with 3.2.01 library

ng-at-sqlexpress-dot-net@ — Tue, 12 Jun 2007 01:42:30 +0200

"giuseppe" <airsoft1@tin.it> wrote in
news:viyn6gqrk1of6nu.110620072005@VDS-472773: 

> I've installed sqlexpress library v. 3.2.01
> after the excution of  few statements I lost connection
> to MySql DBMS (with new and old ODBC drivers)
> with old library 3.0 it's all ok

There should be absolutely no difference between the versions. It may just 
be a coincidence that you lost the connection.

> this is my function to connect to DBMS
> 
>  L_Connection := "Driver=MySQL ODBC 3.51 Driver"
> L_Connection += ";UID=airsoft"
> L_Connection += ";PWD=mypwd"
> L_connection +=" ;server=localhost"
> L_connection +=" ;database="
> local_conn := SQLConnection():new()
> if .not. local_conn:driverConnect(nil, L_Connection,.t.)
> // test also with ==>  if .not. local_conn:driverConnect(nil, 
> L_Connection,,.t.) //
>      return .f.
> endif
> return .t.
> in this way I install only the ODBC without configure it (it's better
> for my customers).
> 
> to work now, I must create a System DNS ODBC
> and configure it with 'enable Auto Reconnect'.

I'm sure you can specify this param in the connect string. The trick is to 
find out what the param is called. To find out how to do that, please see 
slide #8: http://www.sqlexpress.net/sqlxpp/SQLXpp.ppt

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools

Ann: SQLExpress 3.1.24 released

ng-at-sqlexpress-dot-net@ — Mon, 5 Jun 2006 02:55:17 +0200

SQLExpress ver 3.1.24 is now available for download.

This upgrade is provided FREE of charge to all current SQLExpress
subscribers. If you are a registered user, you should have already 
received email notification of the new build; including download and 
installation instructions. 

If you are not a registered SQLExpress user, then please follow the 
hyperlinks below. When you purchase SQLExpress, you will receive one 
full year of free technical support and software updates.

Click here to:

   * Place an order:
     http://sqlexpress.net/register.htm

   * Get a demo:
     mailto:demo@sqlexpress.net?subject=sqlexpress_demo

   * Learn more about SQLExpress:
     http://sqlexpress.net

                            --- * ---

SQLExpress is an object-oriented ODBC library that provides your
Xbase++ application with seamless connectivity to many RDBMS and
ISAM databases. With SQLExpress you will be able to create
industrial strength client/server applications using databases such
as Advantage Database, MS-SQL Server, MySQL, Oracle, DB2, Sybase, 
PgSQL and many others. SQLExpress may also be used with many 
flat-file databases, such as MS-Access, dBase, Paradox and Btrieve.

If you are building mission critical database applications, then
you need SQLExpress!

Best regards,
Boris Borzic
-- 
news://news.Xb2.NET
http://www.Xb2.NET
http://www.SQLExpress.net
industrial strength Xbase++ development tools