Search results for query: *

SELECT SUM(CASE PaperSize WHEN 'Letter' THEN TotalCount ELSE 0 END) AS PaperSize, SUM(CASE PaperSize WHEN 'Letter' THEN 0 ELSE TotalCount END) AS NoPaperSize Testing displays the presence, not the absence of bugs. If a software application has to be designed, it has to be designed correctly!

When you increment the field by + 1 REPLACE YourField WITH INT(YourField+1) Testing displays the presence, not the absence of bugs. If a software application has to be designed, it has to be designed correctly!

Another simple solution: CREATE CURSOR crsTest (F1 M) INSERT INTO crsTest VALUES (FILETOSTR(GETFILE([txt]))) WAIT WINDOW [Number of lines: ] + TRANSFORM(MEMLINES(crsTest.F1)) USE IN crsTest Testing displays the presence, not the absence of bugs. If a software application has to be designed...

Yes. Take a look at images, adding to forms in VFP Help. Testing displays the presence, not the absence of bugs. If a software application has to be designed, it has to be designed correctly!

Try this exec master..xp_msver Testing displays the presence, not the absence of bugs. If a software application has to be designed, it has to be designed correctly!

Or download MSXML 4.0 Service Pack 2 from...

TEXT TO lcSql TEXTMERGE NOSHOW PRETEXT 15 IF object_id('MyTable') IS NOT NULL /* table exists in a SQL Server database */ ALTER TABLE dbo.MyTable ADD newCol nchar(10) NULL ELSE CREATE TABLE [dbo].[MyTable]( [Id] [smallint] IDENTITY(1,1) NOT NULL...

Hi friend01, Init and Load are events and are not methods. Put this line where you want in Init event.

Try in Init event ThisForm.grid1.Refresh

Take a look at http://www.mssqltips.com/tip.asp?tip=1629

NO

Take a look at http://fox.wikis.com/wc.dll?Wiki~VFP9RuntimeFiles~VFP

Here is VFP6 Help from www.microcomplex.com/temp/Vfp6Help.rar

DECLARE @Query1 Char(10) If 1/0 = 10 And 1/1 = 0 Set @Query1 = 'True' Else Set @Query1 = 'False' Print @Query1 Return false [thumbsdown]

Try with WMI CLEAR loCIMV2 = GetObject("winmgmts://localhost/root/cimv2") GetObject("winmgmts://localhost/root/cimv2") loProcesses = loCIMV2.ExecQuery("SELECT * FROM Win32_LogicalMemoryConfiguration") IF loProcesses.Count > 0 For Each objProcess in loProcesses ? "Total Physical...

Define the column's Widths with ColumnWidths Property

Check IN SQL BOL for sp_password

Other way ;~) #define CRLF CHR(13)+CHR(10) LOCAL lcVar lcSaveFile = PUTFILE("where to save") IF EMPTY(lcSaveFile) MESSAGEBOX("No File selected ?") RETURN ENDIF SCAN IF yourcondition = .t. lcVar = TRANSFORM(RECNO())+[;]+YourFld1+[;]+YourFld2+CRLF...

Visual FoxPro cannot update the specified cursor because it is read-only. This can occur when attempting to write to a file created or accessed for read-only purposes.

Hi randallJ, #define CRLF CHR(13)+CHR(10) LOCAL lcVar lcVar = [] SCAN ... lcVar = lcvar + TRANSFORM(RECNO())+[;]+YourFld1+[;]+YourFld2+CRLF ... ENDSCAN ... STRTOFILE(lcVar,PUTFILE("where to save"))