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!

  • Congratulations strongm 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. Zografski

    Combine 2 aggregate queries into one select statement?

    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!
  2. Zografski

    change value of decimal

    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!
  3. Zografski

    Counting the number of lines in a text file VFP

    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...
  4. Zografski

    Embedding Images to VFP?

    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!
  5. Zografski

    Version of SQL

    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!
  6. Zografski

    Error: 0: Class definition MSXML2.DOMDOCUMENT.4.0 is not found.

    Or download MSXML 4.0 Service Pack 2 from...
  7. Zografski

    How to determine if table exist using Transact SQL

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

    Grid doesn't always refresh

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

    Grid doesn't always refresh

    Try in Init event ThisForm.grid1.Refresh
  10. Zografski

    Sql Statement to know Data Size

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

    Q about GDI+ DLL for distributions

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

    Online Help Manual for VFP?

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

    SQL Teaser

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

    Physical Memory

    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...
  15. Zografski

    Listbox column alignment

    Define the column's Widths with ColumnWidths Property
  16. Zografski

    Change password in ODBC..?

    Check IN SQL BOL for sp_password
  17. Zografski

    Outputting results to a text file

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

    Error 111 foxcode table not found

    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.
  19. Zografski

    Outputting results to a text file

    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"))

Part and Inventory Search

Back
Top