Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: mut jayan
  Where is mut jayan?
 chennai
 India
 mut jayan
 Tags
Subject: RE: Blank record
Thread ID: 311181 Message ID: 311201 # Views: 48 # Ratings: 1
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Wednesday, June 29, 2011 4:27:12 PM         
   


> How to write SQL Query for find blank record of all field of my "student.dbf" table?

Why would you let it to happen in the first place. Anyway VFP is forgiving, you can do something like this:

SELECT * FROM (_samples+'data\Customer') INTO CURSOR xx readwrite
USE IN 'Customer'

* Create some 'blank' records
INSERT INTO xx (cust_id) VALUES ('dummy1')
INSERT INTO xx (cust_id) VALUES ('dummy2')

SELECT * FROM xx INTO CURSOR yy WHERE .F. readwrite
APPEND BLANK

lcBlank = SYS(2017,'cust_id',1,3)

SELECT * FROM xx WHERE m.lcBlank = SYS(2017,'cust_id',1,3)


Here a 'blank' record is defined a record where all fields is blank (excluding Cust_id).

Cetin Basoz

.Net has got better.Think about moving - check my blog:
My Blog
Blog (mirror) - sounds to be down

ENTIRE THREAD

Blank record Posted by mut jayan @ 6/29/2011 1:41:40 PM
RE: Blank record Posted by Russell Hill @ 6/29/2011 2:27:09 PM
RE: Blank record Posted by Cetin Basoz @ 6/29/2011 4:27:12 PM
RE: Blank record Posted by onytoo @ 6/29/2011 8:35:56 PM