Re: Trouble managing OVRDBF inside a program
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <AS8PR08MB91194924485ACF31DA1D979CFF9BA@AS8PR08MB9119.eurprd08.prod.outlook.com> |
Hi Luca - good to hear about 24/7 🙂 Likely the best approach here might be to use a create alias for every Library/file combo you need to update. You can create the alias in qtemp ( it will be a ddm-file object ). Then you will be able to keep your sql-logic almost intact. This is the same as making alcohol the main course but ..... 😱 Best regards Stefan -- No trees were killed in the sending of this message, but a large number of electrons were terribly upset. Stefan Tageson +46 732 369934 [email protected]<mailto:[email protected]> ________________________________ From: RPG400-L <[email protected]> on behalf of Luca Giammattei <[email protected]> Sent: Tuesday, February 3, 2026 10:09 To: [email protected] <[email protected]> Subject: Re: Trouble managing OVRDBF inside a program Il 03/02/2026 09:55, [email protected] ha scritto: > Hi, Sorry for being late to the party. My understanding is that you are using OVRDBF in combination with SQL based io ( Insert ). > If so - I guess that after the second I/O sql manager keep the file open regardsless of what you do in terms of open/close. > And if the file is still open it will not honor your ovrdbf's. > Run in debug mode and what's going on. > > > Best regards > > > > Stefan Hi Stefan, don't worry, we're open 24/7 :-) I've pretty much come to the same conclusion: mixing legacy access and SQL in the same program isn't a good idea, much like mixing different types of alcohol during a meal or party isn't exactly a good idea. :-) Thanks. -- This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/rpg400-l or email: [email protected] Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l. Please contact [email protected] for any subscription related questions. -- This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/rpg400-l or email: [email protected] Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l. Please contact [email protected] for any subscription related questions.