Hi,
I m working on MS Acces to SQL Server 2005 conversion. I m using VB6.0 as Front End. Hence I m using RecordSets. so please help me in solving following query...
SHAPE {select stlcode , SampleTypeCode,InNo,NoOfSamples,RecdDistrict,RecdT al,DtRecd , RecdFrom, RecdNameDesg, PrimaryInNo, MicroInNo, WaterInNo from SInward order by SampleTypeCode,InNo } AS ParentCMD APPEND ({select SampleType,InNo,SrNo,StlCode,AStlCode,SampleTakenD t,FarmerNm,FarAddVil,FarAddPost,FarAddDist,FarAddT al,FarAddPin,SurveyGrNo,ReprArea,LastSeason,LastSe asonCrop,NextSeason,NextSeasonCrop,NextSeasonCrop2 2,AgeOfTree,LandProfile,DepthFrom,DepthTo,WaterSou rce,CollectdBy,SampleAccepted,LabSampleNo,HCNumber , MicroLabSampleNo, WaterLabSampleNo from SDetails order by SrNo } AS ChildCMD RELATE SampleTypeCode TO SampleType, InNo to InNo, stlcode to stlcode) AS ChildCMD
I just only came to know that childCMD is Appended to ParentCMD table but not able to find equivalent key words for 'APPEND' and ' SHAPE', 'Relate'
I m not able to