Search results for query: *

Thanks Olaf, spot on! Tom

Hi Ilyad, thanks for the reply. I'm using VFP 9. I want the Prev/First buttons to be disabled when the user moves to the first record (as a visual indicator that they are now on the first record and can't go any further in that direction). But unless I'm missing something, it seems that BOF...

Sorry everyone, I must be half asleep or something. My code is actually checking the RECNO(). e.g. IF RECNO() = 1 THEN *disable First, Prev buttons ENDIF IF RECNO() = RECCOUNT() THEN *disable Next, Last buttons ENDIF

I am working with local cursors created from a SQL Server using the SQLEXEC command. Some records are not required and these are deleted. I have SET DELETED ON so that the deleted records do not show up. I have record mover buttons (First|Prev|Next|Last) to allow users to navigate between the...

Cool, thanks for that Baltman - I had a feeling it might be the asynchronous setting but was struggling to get a proper understanding of how it worked. Again, sorry if people feel that I'm wasting their time here - I just want to get clarification on how the asynchronous calls work. The help...

Hi everyone, sorry if this is a dense question, but I want to run a SQLExec command without having to wait for a reply - is there a way? The idea is that the SQLExec command would be deleting quite a large number of records which might take a minute or so - I don't want the user to have to wait...

I have a VFP application that uses SQL pass-through (SQLEXEC) to connect to a SQL Server backend. Apologies for the following as my lack of proper knowledge of network stuff will make my descriptions a bit wishy-washy. Most of my users are local (London) and the SQL server they are connecting to...

Thanks SQLSister, I actually have Red Gate's SQL Compare and definately agree it's really handy. But my understanding of it is that you need to first use it to compare two specific databases, then use the synchronize script to update one database to have the same structures as the other. I'm...

Hi John, Thanks for your suggestion. The issue that I'm dealing with here is that the database structures of the live system are usually (and intentionally) different from the dev system. In my dev environment I may have some new fields, say for a new feature that I've recently added and have...

Hi, I would like to create a script that I can run against any database (call it the *source* database). What it would do is look through all tables and Stored procedures and generate a new script (let's call it DBMaint) that would re-create the *source* database completely. However, I'd like to...

Hi Tobsen69, Thanks for the that. I did a bit of a web-trawl when looking into this and also came across CVS (plus an offshoot called Subversion). The other biggies seem to be Rational ClearCase and SourceGear Vault. I think we're going to plump for Vault, it sounding like the easiest option...

I have been using VSS for the last year or two and though it seems to do a pretty decent job, I'm interested in what else is out there to handle source version control. Does anyone know of any equivalent packages (in terms of features and capability) that could be viewed as a serious alternative...

Cool! What a useful thing! Now how long has everyone known about this??? Why didn't anyone tell me?! ;) Looking at how handy this is, I'm guessing I look pretty silly for never having seen it before, but finding the answer makes it worth the embarrasment of asking. Thanks, Tom

Sorry gang, think I just answered this one - just opened the .VCT file in notepad and that seems to show me everything.

Hi, I have a rather large class library and somewhere hidden inside it, there is an object that contains code to turn the set the cursor off (e.g. SET CURSOR OFF). Is there a way that I can avoid going into each an every object in turn and doing a search until I find the code? I'm thinking...

Thanks again for your input Rac2, that all makes complete sense. Tom

Thanks Rac2, some interesting points for me to think about. To give this some 'real world' context, I'm talking about a table of Loans. Some loans have an associated insurance policy. A loan can have only have one policy (or none), but a single policy can cover several loans. So our LOAN table...

Hi everyone, I've just started using the 'Diagrams' section of SQL Enterprise Manager. I'm completely new to it, so this is probably a very basic question. I've set all the relationships between tables (linking pks to fks across tables), but some of these relationships are optional (i.e. can...

Thanks mysticmart, the instructions I was given were to use the 'Copy table(s) and view(s) from the source database' option. The copy objects works perfectly, thanks a lot, Tom

We'll often want to do a quick DTS (Export data...) between our dev server and our live server. A problem with this is that although the data and tables are copied across successfully, any varchar fields are converted to text(16) fields. Has anyone come across this before? Is there a way of...