Search results for query: *

In the T-SQL window I have created some temporary tables using the syntax SELECT * INTO #MyTempTable FROM MyTable. Where can I find what temporary tables are currently available (I don't want to delete them yet using DROP TABLE ...)? I cannot find them in any enterprise mgr. table listing...

I have a table containing hundreds of duplicate records (even the primary key is duplicated!) which I wish to remove. The first thing that came to mind was SELECT DISTINCT * FROM MyTable, but MyTable contains a text field, hence I get the error "The text, ntext or image data type cannot be...

I have encountered a problem with my application framework and would appreciate input from other developers before deciding which way to go. When allocating a unique identifier (or primary key, usually an integer value) to each new record, is it better to allocate a) immediately the record is...

Once a form is showing, I need to ascertain if the value of a property has changed from the value originally set in the PEM sheet. I have tried using PEMSTATUS(object,property,0), but this returns .T. even if the value was changed manually from the default value in the PEM sheet at design-time...

My client is running an insurance sales website which invites users to complete a form which is then submitted, a premium calculated, and (hopefully) a sale made via a credit-card transaction. Up to now the premium calculation has been very straightforward (ie. a flat-rate monthly or annual...

I have a domestic telephone installation with 2 analog and one digital ISDN line (provided by British Telecom under the name 'Home Highway'). The ISDN line is connected via a CAT5 patch cable to an external USB Hayes Terminal Adapter, and from there to a laptop via a USB cable. The arrangement...

I have created a backup batch file using the XCOPY command, and it works fine, except for the fact that the files copied to a CD all contain date and timestamps of when they were copied. Has anyone any idea how to keep the original date and time? As far as I can see there are no switches which...

Hope this is the right forum for this type of question - if not, feel free to move it to the right area... As of this morning I've noticed that whenever I boot my pc, as well as starting all the programs in the Start menu, the 'Dial-up Connection' box pops-up and tries to start dialling my ISP...

I have a networked VFP7 application (an .exe running with the runtime libraries). The application runs with no problems at all on the main file-server (let's call this pc1). However, on another machine connected to the network (pc2), I sometimes (about 1 time in 4 at present, but gradually...

I am connecting to a pc (let's call it pc1) using pcAnyWhere and want to run a program from a shortcut on the desktop of another pc (pc2) which is connected to pc1 via. a network (both the host and remote machines are running XP Pro). I can see the shortcut to the program on pc2 and it runs it...

I am trying to create a remote view which selects all fields from a SQL table, plus an extra logical field (not related to any back-end field). Using native tables, I could use syntax like... SELECT *, .F. AS MyNewField ; FROM MySQLTable ; WHERE MyFilterCondition but I get an 'incorrect...

Hi, I have a .sql script to create SQL tables, but I am using MSDE instead of SQL-server. How can I run the script using T-SQL syntax? Thanks, Alan

I am trying to work out what the difference is between the listbox.DisabledForeColor and DisabledItemForeColor properties (same applies to the ...BackColor) . The VFP8 help file is not very helpful - can anyone help me out here? Many thanks, Alan

Using VFP 8, I have a maintenance form toolbar class containing the usual add/edit/delete/print etc. buttons. I want to change the spacing between buttons by inserting some more separators and deleting others. The problem is that when I save the modified class, and reopen it, the new...

I am having a problem with form objects (especially a particular combobox) that repeatedly 'flash' when a form is being instantiated for the first time. Upon setting a breakpoint on the first line of the combo.refresh method I find it runs 4 times before the form 'settles'! At the 1st break...

In my VFP application framework I currently use this.readonly=.T. for textboxes, editboxes and grids that I don't want edited. I have favored this over this.enabled=.F. because I still want the users to enter the control and scroll to see data that may not be in the visible area of the...

In my foundation textbox class, if I want to prevent a user changing the value I prefer to make it readonly rather than disabled. The main reason for this is that if the current value is too long for the visible area of the control, the user can still press the right-arrow or end-key to see the...

I am outputting a (very old, hand-coded) report directly to a printer using ??? for print commands and @ SAY for text posisitioning. I want some lines to be output in double-width font. The code looks something like this... SET DEVICE TO PRINT SET PRINT TO ??? CHR(27)+'@' && reset...

When I view any Word document, it displays the text in only one font (looks like Courier), even if the document was originally prepared in another font, or a mixture of fonts. When I display the available fonts from the pulldown-list on the toolbar, I see that there are only 3 fonts available...

Microsoft Word - I am trying to print a document that has about 400 pages. I want it to print continuously because the pages are perforated and I want them to stay that way. Each ‘page’ is only 11cm x 8 cm – more like a large label. I have set the ‘page’ set up stating width and height and...