Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to tell if variable or field
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01309758
Message ID:
01309814
Views:
6
>GIVE ME SQL QUERY :-))))))))))))))

Ok, since it gives me an error "Incorrect syntax Near ','", but doesn't tell where:
INSERT INTO Registration
                      (FirstName, CreatedOn, LastUpdated, DefaultPicture, Pwd, UserName, SiteID, Comment, Deleted, PersonType, CellPhone, HomePhone, ScreenName, 
                      Email, State, Zip, City, Address2, Address1, Gender, LastName, MiddleName, DOB, Grade, School, Medications, DietRestrictions, Allergies, 
                      CurrentPoints, TotalPoints, MitzvahRewardsID, MedicalConcerns,, NonActivities, LTetnus, TylenolAllowed, AspirinAllowed, MedicalInsurance, 
                      PolicyNum, EmergencyContact, RelationshipContact, EmergencyContactPhone, Physician, PhysicianPhone, Hospital, ToiletTrained, Pets, 
                      TherapiesDetails, NamesAgesSiblings, ChildDescription, ChildsCommunicationSkills, FavActivities, LFavActivities, GainFromFC, HeardAboutFC, 
                      WantFriendAtHome, Interviewed, PublishPictures)
SELECT     People.FirstName, People.CreatedOn, People.LastUpdated, People.DefaultPicture, People.Pwd, People.UserName, People.SiteID, People.Comment, 
                      People.Deleted, People.PersonType, People.CellPhone, People.HomePhone, People.ScreenName, People.Email, People.State, People.Zip, People.City,
                       People.Address2, People.Address1, People.Gender, People.LastName, People.MiddleName, People.DOB, Volunteers.Grade, Volunteers.School, 
                      Volunteers.Medications, Volunteers.DietRestrictions, Volunteers.Allergies, Volunteers.CurrentPoints, Volunteers.TotalPoints, 
                      Volunteers.MitzvahRewardsID, Friends.MedicalConcerns, Friends.Medications AS Expr1, Friends.NonActivities, Friends.LTetnus, 
                      Friends.TylenolAllowed, Friends.AspirinAllowed, Friends.MedicalInsurance, Friends.PolicyNum, Friends.EmergencyContact, 
                      Friends.RelationshipContact, Friends.EmergencyContactPhone, Friends.Physician, Friends.PhysicianPhone, Friends.Hospital, Friends.ToiletTrained, 
                      Friends.Pets, Friends.TherapiesDetails, Friends.NamesAgesSiblings, Friends.ChildDescription, Friends.ChildsCommunicationSkills, 
                      Friends.FavActivities, Friends.LFavActivities, Friends.GainFromFC, Friends.HeardAboutFC, Friends.WantFriendAtHome, Friends.Interviewed, 
                      Friends.PublishPictures
FROM         People INNER JOIN
                      Volunteers ON People.PersonID = Volunteers.PersonID INNER JOIN
                      Friends ON People.PersonID = Friends.FriendID
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform