DATE: 04-21-2018: 13:45 : GMT-5

:: Hi all -:

I sat around a while ago and I thought what programs are there for db use that are rad. The 2 i came up with were U++ and lazarus. Today (4-21) I fired up lazarus and in a matter of a half an hour had data aware controls running transactions. You can get data in controls with lazarus in literally a minute or two if you are fast. I think the half hour included my install. I will be focusing on db this week while away from work. Time to go watch philadelphia versus miami heat. Have a very cool weekend.

After waiting for ocesql to post new code, I decided to check out some different stuff. I fooled with U++ and now esqlOC. The esqlOC is a preprocessor for Cobol that lets you use embedded sql with odbc databases. You can download sergey's cobol binaries at GnuCobol and then copy the commands and make .bat files to compile and execute after you preprocess.

I felt it is worth the effort because you can move data out of cobol .dat files with this tool if you want to, and put it in a db.

Now, I can work with postgresql or firebird, Cobol, and U++.

Brian, at GnuCobol put an event loop with Tcl/TK also that is really cool.

My next step is to start writing code and practicing db stuff. This week at work is going to be difficult, but after next week, maybe I can get started practicing my skills using some of these new tools that are available.

April is just around the corner. Have a cool rest of March. Thx. for visiting

I ran Brian Tiffin's cobol code to get JimTcl to work and then fired it up. I needed to add -fstatic-call or something like that in the terminal in addition to the other switches because the library is static. I found that solution on one of my old posts from before when I used to hang out at GnuCobol. Back then, I tried to start at the end and not the beginning. I wanted to extend everything. From memory, the whole command for JimTcl per Brian's faq is:
cobc -x -fstatic-call -o program1 tcl.cob -I/usr/local/include -L. -ljim

Tomorrow, I plan on doing more activities to extend COBOL. I am hoping my plans go smoothly. I don't want to bother them over at GnuCobol.

In my funk today, and after talking to Brian at cygwin, I found simpleclip on git to help with cutting and pasting into emacs. You probably say "cut and paste" why doesn't it work out of the box. In my infinite wisdom, I think I installed the non X window version of emacs. This does not make the clipboard happy between windows and cygwin. Simpleclip at least fixes the emacs app issue in cygwin.

For the other scenarios I have a secret weapon:
cat /dev/clipboard >> ~/gt1 .

I am using windows chrome browser instead of XWin midori. Because of this, I have XWin and windows clipboard issues. That command appends my copy command in my browser to the file gt1 located in my home directory in cygwin. I leave mousepad open and then hit reload. it gets appended to the end of the file. From there, I can copy it into my geany editor. It is an intermediary fix, but without it, I can't cut and paste all those cool commands from snippets etc.

I just fired up firebird with Soci and Cobol yesterday!

I put the master branch of Soci (soon to be 4.0) on my PC and ran a query against it using firebird as the back end. One thing I think I vaguely recall for SOCI is you may need to specify with export or other the LD_LIBRARY_PATH that gives the location of the SOCI library. I am not in linux right now, but I think that happened to me.

I tried U++ and it is working now. Novo got firebird in the bazaar working. I told him I couldn't get it to work and he fixed it fast. I plan on checking out firebird with C++ using that interface very soon. I tested it against a query to see if it works in the sample database, and it connected and returned the data with ease.

By hook or by crook - rdp with ssh!

I tinkered with ssh and rdp. I found a solution that worked with a bridged adapter from virtualbox to do rdp with ssh tunneling. Still can't use nat adapter or nat network adapter with port forwarding. Not willing to turn my firewall into swiss cheese to get that to work.

I tossed out the idea of ever using VNC for my home. I like ssh with rdp. I think I could set it up faster next time as I am aware of some pitfalls. I can connect either on the command line or putty | remmina securely with rdp. I did it with cygwin ssh connecting to virtualbox RDP server and virtualbox guest ssh server.

Latest... shopping in my future