Search results for query: *

A big thank you to Cetin, your two tips about instancing the table [table] t and then specifying the fields as t.field, along with the creation of the dummy udl file has been a Godsend. My mail merge had worked for years on many computers, then suddenly stopped working in what I can only guess...

I am looking to allow remote users access to our network using VPN and PCAnywhere / Terminal Services. I am looking for the fastest and simplest way to do this, rather than the cheapest way, so if we need to spend money we will as long as it's not over the top. System: Netgear DG834G router /...

Oh, that's much better Derren [Mediocre talent - spread really thin]

User myusername is not a valid user in the database not_the_database_I_am_connecting_to" Here's a frustrating one: I have a new webhost with SQL server 2000 running my database. I have always used a DTS package to backup the database to my local SQL 2000 using "copy objects and data" as I am...

I am just passing through, so as a quickie, try: cast(cast(decisionmonth as varchar(4)) + cast(Decisionday as varchar(2)) + substring(cast(decisionmonth as varchar(20)),7,20) as datetime) Derren [Mediocre talent - spread really thin]

Hi All I have exactly the same set up and am interested if you have had any success with this? Greg, you seem to have the answers, but like Darren and Gensan I am unable to find a setting which matches that (and just a little scared of opening up a little too much to the outside world!) Derren...

Is there any way to find out what version my tables are? The front end is a dos based system and I really need to know if the tables are in a version that I can convert to from vfp6 - copy to newtable.dbf type fox2x There are project files and and it is all open source so I can look anywhere...

Thanks for that I have now tested the table buffering and I can update just the row that I am working on and still make updates using the fp2.6 system. You've been a great help - ta! Please let me know if there are any pitfalls I should be aware of though. Derren [Mediocre talent - spread...

Glennpd Thanks, it seems that you are correct as long as I set the buffering mode to 5 (optimistic table) rather than the 3 (optimistic row). I have tried a number of times to word this, but it always comes out as rubbish, so please try to interpret it the best you can. When one user in a...

I have been holding back on adding any extra fields to the old tables in case they are converted into a vpf6 type - I know, it may be a stupid presumption, but I would rather be safe than sorry. However, following on from my post I thought I would take an old table, add a couple of fields and...

I am updating a very old 2.6 foxpro app by slowly migrating elements of the app into vfp6 - the thing is working great, but needs lots of new features and we can't afford to risk a full rewrite in one go. That's fine, but when I open one of the old tables and set buffering to 3 I can't seem to...

I have another update, which is that you need to add SET NOCOUNT ON to the SP. This will prevent the messages such as "4 row(s) affected" from being returned. As there are more than one messages returned from the SP it must freak out the connection. I have added it to my SP and the recordset...

Hi Chaps I have just come across this and have discovered, half by accident, and half by some distant memory, that (and I stand to be corrected) you cannot return a recordset from a stored procedure if there is an update in the SP as well. Comment out the update and try it again - I will have...

Superb! What can I say - have a great big star from me, especially for the concise answer! Thanks a lot! Derren [Mediocre talent - spread really thin]

Well, obviously it has stumped you as well In the end I needed to change all of my input parameters to varchar and then convert them to bigint or int within the stored procedure, and this worked. I can't help but think that this is not right or proper though Derren [Mediocre talent - spread...

Hi I have a textbox with a controlsource of a date field of a table. The format is set to 'D' (and it has been tried without this as well) The problem is that if you enter an invalid date then in the fox environment you get "invalid date, press space" but when the app is run on a...

Hi I have been testing and running a SQL server 2000 web application using stored procedures, and it is running a treat. However, now that the database and application is posted onto the web I get this error when executing a stored procedure with any parameters: Microsoft OLE DB Provider for...

Thanks SQLsister, that's brilliant advice, I feel I can now proceed using selects where necessary, knowing that I am doing it the right way. Thanks also to sguslan for your response Derren [Mediocre talent - spread really thin]

Dunce's question ... Is there a SQL equivalent of the following steps which I would take using foxpro: If I wish to get a value from a row in a table and insert it into another table/manipulate it/update something etc. I would select the table and locate the record that I wished to look at...

Brilliant, thanks a lot for that Derren [Mediocre talent - spread really thin]