Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update date and skip sunday
Message
 
 
À
05/05/2022 15:01:10
Thomas Ganss (En ligne)
Main Trend
Frankfurt, Allemagne
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01684337
Message ID:
01684346
Vues:
39
>search help for dow()
>
>HTH
>thomas
>
>>
>>CREATE table date_step (sno n(6),datex date, subject C(20))
>>SET DATE TO DMY
>>
>>INSERT into date_step(sno,datex,subject) VALUES (1,{^2022-05-02},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (2,{^2022-05-03},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (3,{^2022-05-04},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (4,{^2022-05-05},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (5,{^2022-05-06},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (6,{^2022-05-07},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (7,{^2022-05-09},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (8,{^2022-05-10},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (9,{^2022-05-11},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (10,{^2022-05-11},'science')
>>
>>Now I want to update record like this. 
>>start from new date and skip Sunday
>>
>>
>>INSERT into date_step(sno,datex,subject) VALUES (5,{^2022-05-02},'science')&& start from 5
>>INSERT into date_step(sno,datex,subject) VALUES (6,{^2022-05-03},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (7,{^2022-05-04},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (9,{^2022-05-05},'science')&& skip sunday
>>INSERT into date_step(sno,datex,subject) VALUES (10,{^2022-05-06},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (11,{^2022-05-07},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (12,{^2022-05-09},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (13,{^2022-05-10},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (14,{^2022-05-11},'science')
>>INSERT into date_step(sno,datex,subject) VALUES (16,{^2022-05-11},'science')&& skip sunday always skip sunday
>>...................................................
>>
>>
yes but how to skip date
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform