Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>I don't see anything wrong with it. How do you know that requery doesn't work?
>
>>
>>SELECT Company.orgname, Company.statecorpi, Company.stateoforg,;
>> Company.fiscyrend, Company.orgdate, Company.citybuslic,;
>> Company.countybusl, Company.statebusli, Licenses.licenseid,;
>> Licenses.companyid, Licenses.code, Licenses.filingfee, Licenses.statetax,;
>> Licenses.agency, Licenses.address1, Licenses.address2, Licenses.city,;
>> Licenses.postal, Licenses.county, Licenses.country, Licenses.phone,;
>> Licenses.internatio, Licenses.intadd, Licenses.type, Licenses.dt1,;
>> Licenses.dt2, Licenses.dt3, Licenses.dt4, Licenses.dt5, Licenses.dt6,;
>> Licenses.dt7, Licenses.dt8, Licenses.dt9, Licenses.dt10, Licenses.dt11,;
>> Licenses.dt12, Cmstates.state, Licenses.citylic, Licenses.countylic,;
>> Licenses.statelic, Licenses.foreignlic, Licenses.otherlic,;
>> Licenses.dtype, Licenses.taxidno, Company.companyid, Cmstates.code,;
>> Company.stateofind,;
>> IIF(Licenses.dtype=1,Licenses.dt4,IIF(Licenses.dtype=2,Licenses.dt5,IIF(Licenses.dtype=3,Licenses.dt2,IIF(Licenses.dtype=4,Licenses.dt1,DATE())))) AS firstdt,;
>> PADR(IIF(Licenses.dtype=1,"Annual",IIF(Licenses.dtype=2,"Semiannual",IIF(Licenses.dtype=3,"Quarterly",IIF(Licenses.dtype=4,"Monthly","No Data")))),12) AS datetype;
>> FROM ;
>> nch_mgr!company ;
>> INNER JOIN nch_mgr!licenses ;
>> ON Company.companyid = Licenses.companyid ;
>> LEFT OUTER JOIN nch_mgr!cmstates ;
>> ON Licenses.code = Cmstates.code;
>> WHERE Company.companyid = ( ?zcompany );
>> ORDER BY Company.orgname, Licenses.licenseid
Sergey
When I copied the command from the command window and used it in place of the command that didn't work, it worked. I'm guessing that it might have had something to do with my framework. I do appreciate your time.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement