How to separate sql codes using proper format??

[nurikoAnna]

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

I am using &_ as a separator...bec ause 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!