[NF] Passing list of values to SQL Server?

Perhaps I'm approaching this from the wrong angle. Here's my need: I need to send any number of single field values to SQL Server so that several queries can act upon those values. I was originally thinking a temp table but if there's a way I could pass a list of values to a stored

[NF] Currency conversion routine?

Does anyone have a way they convert currencies? The need is for a receiving app whereby they need to have the latest exchange rates available so that the translations between currencies is accurate. tia, --Michael ___ Post Messages to:

Screen scraping from VFP

Wondered whether I should make this NF or not, but seeing how it'll be done from VFP, I figured yeah, it's on topic. There's been talk recently and in the past about screen-scraping web pages. Does anyone have a best practice way of doing this? tia, --Michael

[NF] Creating temp table otf with variable name in SQL Server

Want to generate temp table name in VFP via SYS(2015) and then create temp table in SQL Server. I've got a function called CreateTempTable that takes a parm but it's wrong as it creates a temp table that is named the actual parm! Here's the failed attempt: CREATE PROCEDURE

[NF] Returning record count from SQL Server stored proc that returns cursor

Got a stored procedure that returns a record set just fine. There are times however that I just want the count. Rather than creating the SQL logic again, substituting the fields desired with the COUNT(*) instead, is there an easier way to simply say something like give me the @@rowcount of

[NF] SQL Server equivalent to Oracle for parameters/variables?

In Oracle 9i(?), I was able to write stored procedure where I simply referenced the field behind the parameter/variable, thus telling Oracle the type and length implicitly (as it would look it up instead of me hardcoding it). For example, cName as Customers.cName instead of saying cName

[NF] Easier way to debug SQL Server 2000 stored procs?

Gotta hope that there's an easier way than using the Query Analyzer to debug SQL Server 2000 stored procs. What a p.o.s. Again, the tools I had with Oracle9 were MUCH MORE FRIENDLY. Ugh. Suggestions? I want to test from the server, not from Fox. tia, --Michael

Unique indexes are bad because why again?

Having a discussion with other developers and I found an index on a free table that was UNIQUE. Perhaps it's left over from Fox 2.x days, but I'm trying to remember why I've got this memory that it was a no-no and to be avoided? I'm trying to find a copy of HackFox but thought I'd post here

How to get to bottom of listbox when adding new msgs?

Quick question: got a listbox that I'm using for messaging. I want to always show the last message, and thought DoScroll would work nicely, except that the listbox doesn't have a DoScroll method apparently! Suggestions? tia! --Michael ___