Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

StrZero in CDX-index

6 posts in FoxPro Last posting was on 2009-12-20 10:26:59.0Z
Reijo Pitkanen Posted on 2009-12-17 09:11:35.0Z
Date: Thu, 17 Dec 2009 11:11:35 +0200
From: Reijo Pitkanen <reijo.pitkanen@somermatic.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: advantage.foxpro
Subject: StrZero in CDX-index
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 091216-2, 16.12.2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 86.60.191.249
Message-ID: <4b29f55f@solutions.advantagedatabase.com>
X-Trace: 17 Dec 2009 02:09:51 -0700, 86.60.191.249
Lines: 49
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!86.60.191.249
Xref: solutions.advantagedatabase.com Advantage.FoxPro:326
Article PK: 1109680

Hi,

Create Index sql-statement puts Advantage strzero() expression to
CDX-index file, and that cdx-index is not compatible with other non ADS
application.
I consider this as a bug.

Example Delphi-code:
with AdsQueryTmp do
begin
Close;
Sql.Clear;
TNimi := '"TSU'+Formatfloat('00000',NextNro)+'.DBF"';
Sql.Add('CREATE TABLE '+ TNimi+' (TSUNRO Numeric(7,0),TYONUMERO
numeric(6,0),OSANRO Numeric(3,0),');
Sql.Add('VKO Numeric(4,0),TUNNUS Char(10),NIMIKE Char(40),');
Sql.Add('VAVARAUS Numeric(6,0),VAVARAAJA Char(6),VAVARNRO
Numeric(6,0),');
Sql.Add('VAASNUMERO Numeric(5,0),VAASNIMI Char(40), VARIVI
Numeric(4,0),');
Sql.Add('SALDO Numeric(12,4), VARAUS Numeric(12,4), SAAPUU
Numeric(12,4),VALMERA Numeric(12,4),TARVE Numeric(12,4),VAPAA
Numeric(12,4),');
Sql.Add('TEHDAAN Numeric(12,4),JAANNOS Numeric(12,4),TYOH
Numeric(12,4),TYOPV Numeric(12,4),SVVKO Numeric(4,0),');
Sql.Add('SVPVM Date,ALKUPVM Date,APVKO Numeric(4,0) ,ID
Numeric(6,0),TASO Numeric(6,0),RID Char(18)) AS FREE TABLE;');
ExecSql;
Application.ProcessMessages;
Close;
Sql.Clear;
Sql.Add('CREATE INDEX ID ON '+Tnimi+' ( ID, TASO,VKO,RID );');
ExecSql;
Application.ProcessMessages;
Close;
Sql.Clear;
Sql.Add('INSERT INTO '+ TNimi+' SELECT '+Rivi+' as TSUNRO,
CAST(null as SQL_NUMERIC(6,0)) as TYONUMERO,'+
'CAST(null as SQL_NUMERIC(3,0)) as OSANRO, s.*,s.ROWID FROM
#stehtavat s where ID is not NULL');
ExecSql;
end;

This produces index ID ="StrZero(ID)+StrZero(TASO)+StrZero(VKO)+RID"
into the cdx-file.

Is there a way to prevent this behavior?

Regards Reijo Pitkanen


Edgar Sherman Posted on 2009-12-17 15:25:11.0Z
Date: Thu, 17 Dec 2009 08:25:11 -0700
From: Edgar Sherman <no@email.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.5) Gecko/20091204 Thunderbird/3.0
MIME-Version: 1.0
Newsgroups: advantage.foxpro
Subject: Re: StrZero in CDX-index
References: <4b29f55f@solutions.advantagedatabase.com>
In-Reply-To: <4b29f55f@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.24.34.164
Message-ID: <4b2a4cec@solutions.advantagedatabase.com>
X-Trace: 17 Dec 2009 08:23:24 -0700, 10.24.34.164
Lines: 59
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.34.164
Xref: solutions.advantagedatabase.com Advantage.FoxPro:327
Article PK: 1109681

You could use "EXECUTE PROCEDURE sp_CreateIndex" instead of "CREATE
INDEX" to specify the expression you want to use instead.

example:
EXECUTE PROCEDURE sp_CreateIndex('<tablename>', NULL, 'ID',
'STR(ID)+STR(TASO)+STR(VKO)+RID', NULL, 0, 0);

You can also specify the lenght and decimal if you need with STR

Edgar

On 12/17/2009 2:11 AM, Reijo Pitkanen wrote:
> Hi,
>
> Create Index sql-statement puts Advantage strzero() expression to
> CDX-index file, and that cdx-index is not compatible with other non ADS
> application.
> I consider this as a bug.
>
> Example Delphi-code:
> with AdsQueryTmp do
> begin
> Close;
> Sql.Clear;
> TNimi := '"TSU'+Formatfloat('00000',NextNro)+'.DBF"';
> Sql.Add('CREATE TABLE '+ TNimi+' (TSUNRO Numeric(7,0),TYONUMERO
> numeric(6,0),OSANRO Numeric(3,0),');
> Sql.Add('VKO Numeric(4,0),TUNNUS Char(10),NIMIKE Char(40),');
> Sql.Add('VAVARAUS Numeric(6,0),VAVARAAJA Char(6),VAVARNRO Numeric(6,0),');
> Sql.Add('VAASNUMERO Numeric(5,0),VAASNIMI Char(40), VARIVI Numeric(4,0),');
> Sql.Add('SALDO Numeric(12,4), VARAUS Numeric(12,4), SAAPUU
> Numeric(12,4),VALMERA Numeric(12,4),TARVE Numeric(12,4),VAPAA
> Numeric(12,4),');
> Sql.Add('TEHDAAN Numeric(12,4),JAANNOS Numeric(12,4),TYOH
> Numeric(12,4),TYOPV Numeric(12,4),SVVKO Numeric(4,0),');
> Sql.Add('SVPVM Date,ALKUPVM Date,APVKO Numeric(4,0) ,ID
> Numeric(6,0),TASO Numeric(6,0),RID Char(18)) AS FREE TABLE;');
> ExecSql;
> Application.ProcessMessages;
> Close;
> Sql.Clear;
> Sql.Add('CREATE INDEX ID ON '+Tnimi+' ( ID, TASO,VKO,RID );');
> ExecSql;
> Application.ProcessMessages;
> Close;
> Sql.Clear;
> Sql.Add('INSERT INTO '+ TNimi+' SELECT '+Rivi+' as TSUNRO, CAST(null as
> SQL_NUMERIC(6,0)) as TYONUMERO,'+
> 'CAST(null as SQL_NUMERIC(3,0)) as OSANRO, s.*,s.ROWID FROM #stehtavat s
> where ID is not NULL');
> ExecSql;
> end;
>
> This produces index ID ="StrZero(ID)+StrZero(TASO)+StrZero(VKO)+RID"
> into the cdx-file.
>
> Is there a way to prevent this behavior?
>
> Regards Reijo Pitkanen


Reijo Pitkanen Posted on 2009-12-18 09:38:21.0Z
Date: Fri, 18 Dec 2009 11:38:21 +0200
From: Reijo Pitkanen <reijo.pitkanen@somermatic.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: advantage.foxpro
Subject: Re: StrZero in CDX-index
References: <4b29f55f@solutions.advantagedatabase.com> <4b2a4cec@solutions.advantagedatabase.com>
In-Reply-To: <4b2a4cec@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 091217-1, 17.12.2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 86.60.191.249
Message-ID: <4b2b4d23@solutions.advantagedatabase.com>
X-Trace: 18 Dec 2009 02:36:35 -0700, 86.60.191.249
Lines: 80
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!86.60.191.249
Xref: solutions.advantagedatabase.com Advantage.FoxPro:328
Article PK: 1109682

Thanks for advice Edgar,
but when I tried this work around I got error:

poQuery: Error 7200: AQE Error: State = HY000; NativeError = 5132;
[iAnywhere Solutions][Advantage SQL][ASA] Error 5132: The specified
database object name is not valid. "TSU00005" is not a table or view in
the data dictionary.

Well that's true, because the table is a free table, but I think that
this should work also with free tables,shouldn't it?
I tried various ways to give the table name to the sp_CreateIndex
procedure even with fully qualified file path with same result.
The DBF table does exist in database directory and query
SELECT * FROM "TSU00005.DBF" works just fine.

- Reijo

Edgar Sherman wrote:
> You could use "EXECUTE PROCEDURE sp_CreateIndex" instead of "CREATE
> INDEX" to specify the expression you want to use instead.
>
> example:
> EXECUTE PROCEDURE sp_CreateIndex('<tablename>', NULL, 'ID',
> 'STR(ID)+STR(TASO)+STR(VKO)+RID', NULL, 0, 0);
>
> You can also specify the lenght and decimal if you need with STR
>
> Edgar
>
> On 12/17/2009 2:11 AM, Reijo Pitkanen wrote:
>> Hi,
>>
>> Create Index sql-statement puts Advantage strzero() expression to
>> CDX-index file, and that cdx-index is not compatible with other non ADS
>> application.
>> I consider this as a bug.
>>
>> Example Delphi-code:
>> with AdsQueryTmp do
>> begin
>> Close;
>> Sql.Clear;
>> TNimi := '"TSU'+Formatfloat('00000',NextNro)+'.DBF"';
>> Sql.Add('CREATE TABLE '+ TNimi+' (TSUNRO Numeric(7,0),TYONUMERO
>> numeric(6,0),OSANRO Numeric(3,0),');
>> Sql.Add('VKO Numeric(4,0),TUNNUS Char(10),NIMIKE Char(40),');
>> Sql.Add('VAVARAUS Numeric(6,0),VAVARAAJA Char(6),VAVARNRO
>> Numeric(6,0),');
>> Sql.Add('VAASNUMERO Numeric(5,0),VAASNIMI Char(40), VARIVI
>> Numeric(4,0),');
>> Sql.Add('SALDO Numeric(12,4), VARAUS Numeric(12,4), SAAPUU
>> Numeric(12,4),VALMERA Numeric(12,4),TARVE Numeric(12,4),VAPAA
>> Numeric(12,4),');
>> Sql.Add('TEHDAAN Numeric(12,4),JAANNOS Numeric(12,4),TYOH
>> Numeric(12,4),TYOPV Numeric(12,4),SVVKO Numeric(4,0),');
>> Sql.Add('SVPVM Date,ALKUPVM Date,APVKO Numeric(4,0) ,ID
>> Numeric(6,0),TASO Numeric(6,0),RID Char(18)) AS FREE TABLE;');
>> ExecSql;
>> Application.ProcessMessages;
>> Close;
>> Sql.Clear;
>> Sql.Add('CREATE INDEX ID ON '+Tnimi+' ( ID, TASO,VKO,RID );');
>> ExecSql;
>> Application.ProcessMessages;
>> Close;
>> Sql.Clear;
>> Sql.Add('INSERT INTO '+ TNimi+' SELECT '+Rivi+' as TSUNRO, CAST(null as
>> SQL_NUMERIC(6,0)) as TYONUMERO,'+
>> 'CAST(null as SQL_NUMERIC(3,0)) as OSANRO, s.*,s.ROWID FROM #stehtavat s
>> where ID is not NULL');
>> ExecSql;
>> end;
>>
>> This produces index ID ="StrZero(ID)+StrZero(TASO)+StrZero(VKO)+RID"
>> into the cdx-file.
>>
>> Is there a way to prevent this behavior?
>>
>> Regards Reijo Pitkanen


Edgar Sherman Posted on 2009-12-18 17:17:20.0Z
Date: Fri, 18 Dec 2009 10:17:20 -0700
From: Edgar Sherman <no@email.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.5) Gecko/20091204 Thunderbird/3.0
MIME-Version: 1.0
Newsgroups: advantage.foxpro
Subject: Re: StrZero in CDX-index
References: <4b29f55f@solutions.advantagedatabase.com> <4b2a4cec@solutions.advantagedatabase.com> <4b2b4d23@solutions.advantagedatabase.com>
In-Reply-To: <4b2b4d23@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.24.34.164
Message-ID: <4b2bb8b5@solutions.advantagedatabase.com>
X-Trace: 18 Dec 2009 10:15:33 -0700, 10.24.34.164
Lines: 89
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.34.164
Xref: solutions.advantagedatabase.com Advantage.FoxPro:329
Article PK: 1109683

Try creating a new connection in the connection repository as a "free
Table" connection to the directory and run the statement on the new
connection.

Another option would be to add the table to the dictionary.

Edgar

On 12/18/2009 2:38 AM, Reijo Pitkanen wrote:
> Thanks for advice Edgar,
> but when I tried this work around I got error:
>
> poQuery: Error 7200: AQE Error: State = HY000; NativeError = 5132;
> [iAnywhere Solutions][Advantage SQL][ASA] Error 5132: The specified
> database object name is not valid. "TSU00005" is not a table or view in
> the data dictionary.
>
> Well that's true, because the table is a free table, but I think that
> this should work also with free tables,shouldn't it?
> I tried various ways to give the table name to the sp_CreateIndex
> procedure even with fully qualified file path with same result.
> The DBF table does exist in database directory and query
> SELECT * FROM "TSU00005.DBF" works just fine.
>
> - Reijo
>
>
> Edgar Sherman wrote:
>> You could use "EXECUTE PROCEDURE sp_CreateIndex" instead of "CREATE
>> INDEX" to specify the expression you want to use instead.
>>
>> example:
>> EXECUTE PROCEDURE sp_CreateIndex('<tablename>', NULL, 'ID',
>> 'STR(ID)+STR(TASO)+STR(VKO)+RID', NULL, 0, 0);
>>
>> You can also specify the lenght and decimal if you need with STR
>>
>> Edgar
>>
>> On 12/17/2009 2:11 AM, Reijo Pitkanen wrote:
>>> Hi,
>>>
>>> Create Index sql-statement puts Advantage strzero() expression to
>>> CDX-index file, and that cdx-index is not compatible with other non ADS
>>> application.
>>> I consider this as a bug.
>>>
>>> Example Delphi-code:
>>> with AdsQueryTmp do
>>> begin
>>> Close;
>>> Sql.Clear;
>>> TNimi := '"TSU'+Formatfloat('00000',NextNro)+'.DBF"';
>>> Sql.Add('CREATE TABLE '+ TNimi+' (TSUNRO Numeric(7,0),TYONUMERO
>>> numeric(6,0),OSANRO Numeric(3,0),');
>>> Sql.Add('VKO Numeric(4,0),TUNNUS Char(10),NIMIKE Char(40),');
>>> Sql.Add('VAVARAUS Numeric(6,0),VAVARAAJA Char(6),VAVARNRO
>>> Numeric(6,0),');
>>> Sql.Add('VAASNUMERO Numeric(5,0),VAASNIMI Char(40), VARIVI
>>> Numeric(4,0),');
>>> Sql.Add('SALDO Numeric(12,4), VARAUS Numeric(12,4), SAAPUU
>>> Numeric(12,4),VALMERA Numeric(12,4),TARVE Numeric(12,4),VAPAA
>>> Numeric(12,4),');
>>> Sql.Add('TEHDAAN Numeric(12,4),JAANNOS Numeric(12,4),TYOH
>>> Numeric(12,4),TYOPV Numeric(12,4),SVVKO Numeric(4,0),');
>>> Sql.Add('SVPVM Date,ALKUPVM Date,APVKO Numeric(4,0) ,ID
>>> Numeric(6,0),TASO Numeric(6,0),RID Char(18)) AS FREE TABLE;');
>>> ExecSql;
>>> Application.ProcessMessages;
>>> Close;
>>> Sql.Clear;
>>> Sql.Add('CREATE INDEX ID ON '+Tnimi+' ( ID, TASO,VKO,RID );');
>>> ExecSql;
>>> Application.ProcessMessages;
>>> Close;
>>> Sql.Clear;
>>> Sql.Add('INSERT INTO '+ TNimi+' SELECT '+Rivi+' as TSUNRO, CAST(null as
>>> SQL_NUMERIC(6,0)) as TYONUMERO,'+
>>> 'CAST(null as SQL_NUMERIC(3,0)) as OSANRO, s.*,s.ROWID FROM #stehtavat s
>>> where ID is not NULL');
>>> ExecSql;
>>> end;
>>>
>>> This produces index ID ="StrZero(ID)+StrZero(TASO)+StrZero(VKO)+RID"
>>> into the cdx-file.
>>>
>>> Is there a way to prevent this behavior?
>>>
>>> Regards Reijo Pitkanen


Reijo Pitkanen Posted on 2009-12-18 18:05:13.0Z
Date: Fri, 18 Dec 2009 20:05:13 +0200
From: Reijo Pitkanen <reijo.pitkanen@somermatic.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: advantage.foxpro
Subject: Re: StrZero in CDX-index
References: <4b29f55f@solutions.advantagedatabase.com> <4b2a4cec@solutions.advantagedatabase.com> <4b2b4d23@solutions.advantagedatabase.com> <4b2bb8b5@solutions.advantagedatabase.com>
In-Reply-To: <4b2bb8b5@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 091218-0, 18.12.2009), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 86.60.191.249
Message-ID: <4b2bc3f0@solutions.advantagedatabase.com>
X-Trace: 18 Dec 2009 11:03:28 -0700, 86.60.191.249
Lines: 104
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!86.60.191.249
Xref: solutions.advantagedatabase.com Advantage.FoxPro:330
Article PK: 1109684

The "free table" connection is out of question cause the actual database
runs on Linux server, and I don't like to mix samba shares to this soup.
I think that adding the table to the dictionary makes the sp_CreateIndex
procedure to work, but the table that we are dealing with is somewhat
a "global" temporary table that is to be removed from system in a few
days, so it rather should be a free table than a dictionary table,
though making it a dictionary table does not do any harm.

Still the question is: why does the sp_CreateIndex procedure not find
the free table? I think that it should.

- Reijo

Edgar Sherman wrote:
> Try creating a new connection in the connection repository as a "free
> Table" connection to the directory and run the statement on the new
> connection.
>
> Another option would be to add the table to the dictionary.
>
> Edgar
>
> On 12/18/2009 2:38 AM, Reijo Pitkanen wrote:
>> Thanks for advice Edgar,
>> but when I tried this work around I got error:
>>
>> poQuery: Error 7200: AQE Error: State = HY000; NativeError = 5132;
>> [iAnywhere Solutions][Advantage SQL][ASA] Error 5132: The specified
>> database object name is not valid. "TSU00005" is not a table or view in
>> the data dictionary.
>>
>> Well that's true, because the table is a free table, but I think that
>> this should work also with free tables,shouldn't it?
>> I tried various ways to give the table name to the sp_CreateIndex
>> procedure even with fully qualified file path with same result.
>> The DBF table does exist in database directory and query
>> SELECT * FROM "TSU00005.DBF" works just fine.
>>
>> - Reijo
>>
>>
>> Edgar Sherman wrote:
>>> You could use "EXECUTE PROCEDURE sp_CreateIndex" instead of "CREATE
>>> INDEX" to specify the expression you want to use instead.
>>>
>>> example:
>>> EXECUTE PROCEDURE sp_CreateIndex('<tablename>', NULL, 'ID',
>>> 'STR(ID)+STR(TASO)+STR(VKO)+RID', NULL, 0, 0);
>>>
>>> You can also specify the lenght and decimal if you need with STR
>>>
>>> Edgar
>>>
>>> On 12/17/2009 2:11 AM, Reijo Pitkanen wrote:
>>>> Hi,
>>>>
>>>> Create Index sql-statement puts Advantage strzero() expression to
>>>> CDX-index file, and that cdx-index is not compatible with other non ADS
>>>> application.
>>>> I consider this as a bug.
>>>>
>>>> Example Delphi-code:
>>>> with AdsQueryTmp do
>>>> begin
>>>> Close;
>>>> Sql.Clear;
>>>> TNimi := '"TSU'+Formatfloat('00000',NextNro)+'.DBF"';
>>>> Sql.Add('CREATE TABLE '+ TNimi+' (TSUNRO Numeric(7,0),TYONUMERO
>>>> numeric(6,0),OSANRO Numeric(3,0),');
>>>> Sql.Add('VKO Numeric(4,0),TUNNUS Char(10),NIMIKE Char(40),');
>>>> Sql.Add('VAVARAUS Numeric(6,0),VAVARAAJA Char(6),VAVARNRO
>>>> Numeric(6,0),');
>>>> Sql.Add('VAASNUMERO Numeric(5,0),VAASNIMI Char(40), VARIVI
>>>> Numeric(4,0),');
>>>> Sql.Add('SALDO Numeric(12,4), VARAUS Numeric(12,4), SAAPUU
>>>> Numeric(12,4),VALMERA Numeric(12,4),TARVE Numeric(12,4),VAPAA
>>>> Numeric(12,4),');
>>>> Sql.Add('TEHDAAN Numeric(12,4),JAANNOS Numeric(12,4),TYOH
>>>> Numeric(12,4),TYOPV Numeric(12,4),SVVKO Numeric(4,0),');
>>>> Sql.Add('SVPVM Date,ALKUPVM Date,APVKO Numeric(4,0) ,ID
>>>> Numeric(6,0),TASO Numeric(6,0),RID Char(18)) AS FREE TABLE;');
>>>> ExecSql;
>>>> Application.ProcessMessages;
>>>> Close;
>>>> Sql.Clear;
>>>> Sql.Add('CREATE INDEX ID ON '+Tnimi+' ( ID, TASO,VKO,RID );');
>>>> ExecSql;
>>>> Application.ProcessMessages;
>>>> Close;
>>>> Sql.Clear;
>>>> Sql.Add('INSERT INTO '+ TNimi+' SELECT '+Rivi+' as TSUNRO, CAST(null as
>>>> SQL_NUMERIC(6,0)) as TYONUMERO,'+
>>>> 'CAST(null as SQL_NUMERIC(3,0)) as OSANRO, s.*,s.ROWID FROM
>>>> #stehtavat s
>>>> where ID is not NULL');
>>>> ExecSql;
>>>> end;
>>>>
>>>> This produces index ID ="StrZero(ID)+StrZero(TASO)+StrZero(VKO)+RID"
>>>> into the cdx-file.
>>>>
>>>> Is there a way to prevent this behavior?
>>>>
>>>> Regards Reijo Pitkanen


Joachim Duerr (ADS) Posted on 2009-12-20 10:26:59.0Z
From: "Joachim Duerr (ADS)" <jojo.duerr@gmx.de>
Subject: Re: StrZero in CDX-index
Newsgroups: Advantage.FoxPro
References: <4b29f55f@solutions.advantagedatabase.com> <4b2a4cec@solutions.advantagedatabase.com> <4b2b4d23@solutions.advantagedatabase.com> <4b2bb8b5@solutions.advantagedatabase.com> <4b2bc3f0@solutions.advantagedatabase.com>
Date: Sun, 20 Dec 2009 11:26:59 +0100
User-Agent: XanaNews/1.19.1.194
X-Face: u2p+</,mb|Ah!x!/qxX5q0t:O~.<1&JzwNHYhSqcviY{~&|iDc"U.Je1A.ZeHR`d;;y#R
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 84.158.153.238
Message-ID: <4b2dfb86@solutions.advantagedatabase.com>
X-Trace: 20 Dec 2009 03:25:10 -0700, 84.158.153.238
Lines: 14
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!84.158.153.238
Xref: solutions.advantagedatabase.com Advantage.FoxPro:331
Article PK: 1109685


Reijo Pitkanen wrote:

>The "free table" connection is out of question cause the actual
>database runs on Linux server, and I don't like to mix samba shares
>to this soup.

"free tables" does not mean to use samba. Just leave out the dicitonary
name from the connection string.


--
Joachim Duerr
Advantage Presales
check out my new ADS book on http://www.jd-engineering.de/adsbuch