How to separate sql codes using proper format??

[nurikoAnna]

how to properly separate sql codes........

I am using &_ as a separator...because it will not suits the visual basic code form...it will skip to the next line that's why I am having trouble in it


Below is my code...please help me separate this using the proper separator and proper format

if CESDBConn.execute ("SELECT `t_application`.`PersonalInfoID`,`t_application`.` DateOfApplication`,`t_application`.`SchoolLastAtte nded`,`t_application`.`SLAAddress`,`t_application` .`GeneralAverage`,`t_application`.`CourseID`,`t_ap plication`.`SchoolYearID`,`t_personalinfo`.`FName` ,`t_personalinfo`.`MI`,`t_personalinfo`.`LName`,`t _personalinfo`.`BirthDate`,`t_personalinfo`.`Place OfBirth`,`t_personalinfo`.`Age`,`t_personalinfo`.` Gender`,`t_personalinfo`.`HomeAddress`,`t_personal info`.`ContactPerson`,`t_personalinfo`.`ContactPer sonPhone`,`t_personalinfo`.`Father`,`t_personalinf o`.`Mother`,`t_personalinfo`.`HSDateGraduated`FROM `t_application`
 
INNER JOIN `t_personalinfo` ON (`t_personalinfo`.`PersonalInfoID` = `t_application`.`PersonalInfoID`)
 
WHERE (`t_application`.`PersonalInfoID` LIKE '" & .PersonalInfoID & "') 
 
AND (`DateOfApplication` LIKE '" & .DateOfApplication & "') 
 
AND (`SchoolLastAttended` LIKE '" & .SchoolLastAttended & "') 
 
AND (`SLAAddress` LIKE '" & .SLAAddress & "') 
 
AND (`GeneralAverage` LIKE '" & .GeneralAverage & "') 
 
AND (`CourseID` LIKE '" & .CourseID & "') 
 
AND (`SchoolYearID` LIKE '" & .SchoolYearID & "') 
 
AND (`FName` LIKE '" & .FName & "') 
 
AND (`MI` LIKE '" & .MI & "') 
 
AND (`LName` LIKE '" & .LName & "') 
 
AND (`BirthDate` LIKE '" & .BirthDate & "') 
 
AND (`PlaceOfBirth` LIKE '" & .PlaceOfBirth & "') 
 
AND (`Age` LIKE '" & .Age & "') 
 
AND (`Gender` LIKE '" & .Gender & "') 
 
AND (`HomeAddress` LIKE '" & .HomeAddress & "') 
 
AND (`ContactPerson` LIKE '" & .ContactPerson & "') 
 
AND (`ContactPersonPhone` LIKE '" & .ContactPersonPhone & "') 
 
AND (`Father` LIKE '" & .Father & "') 
 
AND (`Mother` LIKE '" & .Mother & "') 
 
AND (`HSDateGraduated` LIKE '" & .HSDateGraduated & "')").EOF then
 

Please...God bless

[Dököll]

First, I added code tags for ya, then I went ahead and brought down the necessary ANDs to make it more readable.

Is this what you were after? Do stay tuned for other ideas if not:-)

Happy New Year!