>>Thanks a lot, this is a great starting point. I was my halfway of setting these tables up, but then switched to reading some forums, etc. :)
>
>Actually, I didn't even think. To change to the correct database you could do:
>
>
>IF @tcState = 'CT'
> USE CTCredit
>
>IF @tcState = 'MA'
> USE MACredit
>
>
>BOb
Are you sure, I have to switch? Can I use full notation instead in my queries and use USE command.
BTW, do you want a laugh? I have a great book by Mike Levy and others. I wanted today to check some syntax, so I opened a book and I found some codes for triggers, etc. But it was VFP code!!! I was surprised and wrote a message here. And only now, when I looked at the cover of the book, I noticed, that I looked in Effective Technique instead of Client/Server applications with VFP & SQL Server!!!!!!! :)
If it's not broken, fix it until it is.
My Blog