Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. derren

    MailMerge Problem

    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...
  2. derren

    What would be the fastest way to set up VPN?

    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 /...
  3. derren

    concatenate columns

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

    Server validating user in the wrong database

    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...
  5. derren

    concatenate columns

    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]
  6. derren

    Host VPN on win2000 server

    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...
  7. derren

    Which version are my tables? 2.6?

    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...
  8. derren

    can 2.6 tables be buffered in VFP6?

    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...
  9. derren

    can 2.6 tables be buffered in VFP6?

    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...
  10. derren

    can 2.6 tables be buffered in VFP6?

    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...
  11. derren

    can 2.6 tables be buffered in VFP6?

    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...
  12. derren

    Stored Procedure not working

    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...
  13. derren

    Stored Procedure not working

    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...
  14. derren

    App hangs on incorrect date entry

    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]
  15. derren

    Optional feature not implemented

    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...
  16. derren

    App hangs on incorrect date entry

    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...
  17. derren

    Optional feature not implemented

    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...
  18. derren

    Using data from a row - laugh at new guy!

    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]
  19. derren

    Using data from a row - laugh at new guy!

    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...
  20. derren

    Create a Hexadecimal string

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

Part and Inventory Search

Back
Top