|
Find in Bankbots (Sdk)
Find in Bankbots // Sdk
May 23, 2001, 5:57pm
To: All Avid Users Of Aw,
How do you find the name of an avatar in a database?
I am using data controls, & my bankbot can add accounts, but not find
accounts. Data1.Recordset.FindFirst "Both = 'sdk.awAvatarName'"
Does not work, for I get a NoMatch=True vairable, so it returns the first
record in the database. If I take away the the quotes, I get a Jet error. I
know how to do this in SQL, but how can I utilize SQL with the data control?
ANY RELEVANT SUGGESTIONS WELCOME!
Sincerly,
Barbarossa (315942)
P.S. To everone that despises programmers like myself (makaveli,grimble), I
take it as my responsablity to duly inform you that I have created my first
bot, so this will be my second. Want It? Telegram me.
May 23, 2001, 6:08pm
*chuckle* good luck on your bankbot *chuckles again*
[View Quote]"barbarossa" <empbarbarossa at excite.com> wrote in message
news:3b0c1618 at server1.Activeworlds.com...
| To: All Avid Users Of Aw,
| How do you find the name of an avatar in a database?
| I am using data controls, & my bankbot can add accounts, but not find
| accounts. Data1.Recordset.FindFirst "Both = 'sdk.awAvatarName'"
| Does not work, for I get a NoMatch=True vairable, so it returns the first
| record in the database. If I take away the the quotes, I get a Jet error.
I
| know how to do this in SQL, but how can I utilize SQL with the data
control?
| ANY RELEVANT SUGGESTIONS WELCOME!
|
| Sincerly,
| Barbarossa (315942)
|
| P.S. To everone that despises programmers like myself (makaveli,grimble),
I
| take it as my responsablity to duly inform you that I have created my
first
| bot, so this will be my second. Want It? Telegram me.
|
|
|
May 23, 2001, 9:18pm
Ack! Data controls (I hate them myself, but that's just a personal vendetta
against the horrid things ;o) ).
The data control cannot resolve 'sdk.awAvatarName' into what you expect
because you are providing it as a literal (between the quotes), so it is
looking for the text "sdk.awAvatarName" in the field Both, rather than the
result of the expression. You need to build the string yourself, something
like this:
Data1.Recordset.FindFirst "Both = '" & sdk.awAvatarName & "'"
Then the VALUE AwAvatarName property is added between the two literals "Both
= '" and "'" forming
"Both = 'SnagglePuss'".
Grims.
[View Quote]"barbarossa" <empbarbarossa at excite.com> wrote in message
news:3b0c1618 at server1.Activeworlds.com...
> To: All Avid Users Of Aw,
> How do you find the name of an avatar in a database?
> I am using data controls, & my bankbot can add accounts, but not find
> accounts. Data1.Recordset.FindFirst "Both = 'sdk.awAvatarName'"
> Does not work, for I get a NoMatch=True vairable, so it returns the first
> record in the database. If I take away the the quotes, I get a Jet error.
I
> know how to do this in SQL, but how can I utilize SQL with the data
control?
> ANY RELEVANT SUGGESTIONS WELCOME!
>
> Sincerly,
> Barbarossa (315942)
>
> P.S. To everone that despises programmers like myself (makaveli,grimble),
I
> take it as my responsablity to duly inform you that I have created my
first
> bot, so this will be my second. Want It? Telegram me.
>
>
|
May 24, 2001, 7:50pm
Data controls...they're confusing, and you'd be better off having MS
Acces97... I like doing stuff my own way, so I call my DB files .bdb (stands
for Bot DataBase)... they're simple, plain ASCII files with data separated
with comas (,) and are 1 entry/line
KAH
PS. off course, you could do something better, more DB like...
[View Quote]barbarossa wrote in message <3b0c1618 at server1.Activeworlds.com>...
>To: All Avid Users Of Aw,
>How do you find the name of an avatar in a database?
>I am using data controls, & my bankbot can add accounts, but not find
>accounts. Data1.Recordset.FindFirst "Both = 'sdk.awAvatarName'"
>Does not work, for I get a NoMatch=True vairable, so it returns the first
>record in the database. If I take away the the quotes, I get a Jet error. I
>know how to do this in SQL, but how can I utilize SQL with the data
control?
>ANY RELEVANT SUGGESTIONS WELCOME!
>
>Sincerly,
>Barbarossa (315942)
>
>P.S. To everone that despises programmers like myself (makaveli,grimble), I
>take it as my responsablity to duly inform you that I have created my first
>bot, so this will be my second. Want It? Telegram me.
>
>
|
May 24, 2001, 9:09pm
The MS Jet database engine that data controls, QueryDefs, Recordsets, etc.
use is the same database engine that drives MS Access. Its just another way
to utilise MDB files.
Grims
[View Quote]"kah" <kah at kahbot.com> wrote in message
news:3b0d8232 at server1.Activeworlds.com...
> Data controls...they're confusing, and you'd be better off having MS
> Acces97... I like doing stuff my own way, so I call my DB files .bdb
(stands
> for Bot DataBase)... they're simple, plain ASCII files with data separated
> with comas (,) and are 1 entry/line
>
> KAH
> PS. off course, you could do something better, more DB like...
>
> barbarossa wrote in message <3b0c1618 at server1.Activeworlds.com>...
I
> control?
I
first
>
>
|
|