setting up a counter and incremented it within a SQL statement

[alan_atwood]

I am looking to produce a query that will in addition to displaying the
data will generate a counter that will be incremented by one with each
row of the resultset. For example, my resultset would look like this

ABC,123,1
BCD,234,2
CDE,345,3

where the 3rd column is the incremented counter.
Anyone have any ideas on how to do this?

Many thanks,
Alan Atwood

[Mike Preston]

On 7 Jan 2005 12:48:18 -0800, "alan_atwood" <al*********@hotmail.com>
wrote:

I am looking to produce a query that will in addition to displaying the
data will generate a counter that will be incremented by one with each
row of the resultset. For example, my resultset would look like this

ABC,123,1
BCD,234,2
CDE,345,3

where the 3rd column is the incremented counter.
Anyone have any ideas on how to do this?

http://www.lebans.com/rownumber.htm

mike

[alan_atwood]

Thanks Mike. Doesn't work; keep getting a "User-defined type not
defined" and the Visual Basic debugger highlights the following line:

Function Serialize(qryname As String, keyname As String, keyvalue) As
Long

I'm not a VB guy, so any help on this would be appreciated.

Thanks,
Alan

Mike Preston wrote:

On 7 Jan 2005 12:48:18 -0800, "alan_atwood" <al*********@hotmail.com>
wrote:

I am looking to produce a query that will in addition to displaying thedata will generate a counter that will be incremented by one with eachrow of the resultset. For example, my resultset would look like this
ABC,123,1
BCD,234,2
CDE,345,3

where the 3rd column is the incremented counter.
Anyone have any ideas on how to do this?

http://www.lebans.com/rownumber.htm

mike

[Mike Preston]

On 8 Jan 2005 16:02:24 -0800, "alan_atwood" <al*********@hotmail.com>
wrote:

Thanks Mike. Doesn't work; keep getting a "User-defined type not
defined" and the Visual Basic debugger highlights the following line:

Function Serialize(qryname As String, keyname As String, keyvalue) As
Long

I'm not a VB guy, so any help on this would be appreciated.

If you installed the whole thing correctly, you would have error
handling. Did you download the rownumber.zip file? If so, what,
exactly, did you do with it?

mike
Thanks,
Alan

Mike Preston wrote:

On 7 Jan 2005 12:48:18 -0800, "alan_atwood" <al*********@hotmail.com>
wrote:

>I am looking to produce a query that will in addition to displayingthe >data will generate a counter that will be incremented by one witheach >row of the resultset. For example, my resultset would look likethis >
>ABC,123,1
>BCD,234,2
>CDE,345,3
>
>where the 3rd column is the incremented counter.
>Anyone have any ideas on how to do this?

http://www.lebans.com/rownumber.htm

mike

[alan_atwood]

I exported the modules from your db and imported them into my db.

Alan

Mike Preston wrote:

On 8 Jan 2005 16:02:24 -0800, "alan_atwood" <al*********@hotmail.com>
wrote:

Thanks Mike. Doesn't work; keep getting a "User-defined type not
defined" and the Visual Basic debugger highlights the following line:
Function Serialize(qryname As String, keyname As String, keyvalue) AsLong

I'm not a VB guy, so any help on this would be appreciated.

If you installed the whole thing correctly, you would have error
handling. Did you download the rownumber.zip file? If so, what,
exactly, did you do with it?

mike

Thanks,
Alan

Mike Preston wrote:

On 7 Jan 2005 12:48:18 -0800, "alan_atwood" <al*********@hotmail.com> wrote:

>I am looking to produce a query that will in addition to

displayingthe

>data will generate a counter that will be incremented by one with

each

>row of the resultset. For example, my resultset would look like

this

>
>ABC,123,1
>BCD,234,2
>CDE,345,3
>
>where the 3rd column is the incremented counter.
>Anyone have any ideas on how to do this?

http://www.lebans.com/rownumber.htm

mike

[Mike Preston]

On 10 Jan 2005 08:42:34 -0800, "alan_atwood" <al*********@hotmail.com>
wrote:

I exported the modules from your db and imported them into my db.
Would you mind bottom posting? It makes following a discussion quite
a bit easier.

After you imported the modules into your db (BTW, it isn't *my* db, it
is Stephen Lebans' db), what did you do with your query in an attempt
to get a counter column? Please post the SQL for the query that
doesn't work.

If you load just the Lebans' db and click on Queries and then Query1,
do you get a counter column?

mike

Mike Preston wrote:

On 8 Jan 2005 16:02:24 -0800, "alan_atwood" <al*********@hotmail.com>
wrote:

>Thanks Mike. Doesn't work; keep getting a "User-defined type not
>defined" and the Visual Basic debugger highlights the followingline: >
>Function Serialize(qryname As String, keyname As String, keyvalue)As >Long
>
>I'm not a VB guy, so any help on this would be appreciated.
>

If you installed the whole thing correctly, you would have error
handling. Did you download the rownumber.zip file? If so, what,
exactly, did you do with it?

mike

>Thanks,
>Alan
>
>Mike Preston wrote:
>> On 7 Jan 2005 12:48:18 -0800, "alan_atwood"<al*********@hotmail.com> >> wrote:
>>
>> >I am looking to produce a query that will in addition todisplaying >the
>> >data will generate a counter that will be incremented by one with
>each
>> >row of the resultset. For example, my resultset would look like
>this
>> >
>> >ABC,123,1
>> >BCD,234,2
>> >CDE,345,3
>> >
>> >where the 3rd column is the incremented counter.
>> >Anyone have any ideas on how to do this?
>>
>> http://www.lebans.com/rownumber.htm
>>
>> mike
>