Selecting a record that is updating


09-May-2020 02:33

* and others You do not tell us where your code above 'falls apart'.

Does it throw an error message or just not give you the answer you want?

Things like: * where does maxid 'live' * where is curid initialized going into the DO/ENDDO loop?

* is the data table ai_enc already open before the DO/ENDDO loop?

A filter condition should filter some table field, shouldn't it?

If progam is a table field you still don't need extra delimiters just because it's a reserved word.

DO WHILE maxid = curid SELECT era_proj_actuals locate for id1 = curid curprog = prog_id curservcat = serv_catcur1yrstartdt = oneyrstartdtcur1yrenddt = oneyrenddtcurconno = conno IF curservcat in ('00015', '00016', '00017', '00018', '00019', '00043', '00044', '00047', '00048') thencuractenc = (select COUNT(act_id) from ai_enc where conno = curconno and serv_cat = curservcat and 'program' = curprog and act_dt It would be easier to understand, if you come over with the SQL foxpro can't execute.

One thing I spot is you trying to set a variable to an sql result. An SQL ends in a resultset, even select count() dfoes not result in a single scalar value. into cursor cur Resultcuractenc = cur Result.n Count Besides that you can't do IF var in (list of values)What you can do instead is IF inlist(var, list of values)Besides I don't see a rough error.

selecting a record that is updating-38

dating a muslim men

I'm able to do this in sql without any problems but very little translates over well from sql to foxpro.

IF INLIST(curservcat, "00015", "00016", "00017", "00018", "00019", "00043", "00044", "00047", "00048") = . The use of SET FILTER is not a best practice, particularly since you appear to be using it solely for the COUNT.



Tama naman po ang nakasulat sa talata, ang mali lang po ay yung kanilang pang unawa.… continue reading »


Read more

Crystal-clear broadcast quality, rich sound and responsive chat give you the power! Love telling cuties what to do or do you simply enjoy the voyeuristic glimpse into the lives of the naughty?… continue reading »


Read more

I'm very open-minded, can go at whatever pace you prefer and promise we'll both be stimulated and cumming by the end of the call. xx My massive milky tits just loved to be played with. I want you to talk and wank Look at these massive big tits and imagine your cock fucking them as I squeeze your ass and play with your balls. Just call me up immediately and prepare to serve my every single sexual desire without question. My spit is running all down your cock, your ball sack and your asshole. Do you want to rim my moist butt hole with your tongue, or maybe fuck me hard over the sofa? You only need to take one look at me to know I'm going to give you what you want in one of the best red hot steamy phone sex calls you've ever had. Call me now and describe to me how you'll lick, finger and fuck my tight moist asshole. Nudge your fat bell end into me and push hard baby.… continue reading »


Read more

Automated technologies or interactions – as you interact with our website, we may automatically collect the following types of data (all as described above): Technical Data about your equipment, Usage Data about your browsing actions and patterns, and Contact Data where tasks carried out via our website remain uncompleted, such as incomplete orders or abandoned baskets.… continue reading »


Read more