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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Zografski

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

Part and Inventory Search

Back
Top