Liberty BASIC Community Forum
« Search Results »

Welcome Guest. Please Login or Register.
Sep 21st, 2017, 7:53pm


Rules|Home|Help|Search|Recent Posts|Notification

--Liberty BASIC Resources--
Liberty BASIC Community WikiSpace
Frequently Asked Questions
Bay Six Software Forum
Liberty BASIC Home Page
Carl Gundel's Blog
Official Liberty BASIC Support
Liberty BASIC Programmer's Encyclopedia
Liberty BASIC on Rosetta Code

Search Results

Total results: 10


 1   Liberty BASIC Code / Re: unzipping file  on: Yesterday at 10:18pm
Started by Bob | Post by robmcal
http://libertybasic.conforums.com/index.cgi?board=general&action=display&num=1482348124
 
  Reply Quote Notify of replies

 2   Liberty BASIC Code / Re: unzipping file  on: Yesterday at 10:08pm
Started by Bob | Post by Bob
I placed the 7zip file in my Liberty Basic directory and now I cannot access Liberty Basic. Any help would be appreciated. The icon shows on the tool bar but does not show the window, it appears to be in constant minimized stated.
 
  Reply Quote Notify of replies

 3   Liberty BASIC Code / Re: ComboBox Question  on: Sep 18th, 2017, 11:33am
Started by xtal | Post by xtal
It is in the cnc pgm
 
  Reply Quote Notify of replies

 4   Database Applications / Re: Connecting My Program to MySQL Database  on: Sep 10th, 2017, 4:51pm
Started by XpL01T | Post by CryptoMan
You can also use Microsoft SQLServer Express which is a FREE version.

Maybe, you will have less problems with MS SQL.

Once you install MS SQLServer Express and ODBC driver, you can use the same software by only changing the connection string.

If you want to try this, I can send you the MS SQL connection string.

SQL is SQL. Unless you already have MySQL up and running and not struggling with MySQL, I can understand but if you are looking for a good and free SQL database, MS SQLServer Express is more than enough. Learn how to use SQL with MS SQLServer and later you can try others like MySQL or PostgresSQL https://www.postgresql.org/
 
  Reply Quote Notify of replies

 5   Liberty BASIC Code / Re: unzipping file  on: Sep 10th, 2017, 02:03am
Started by Bob | Post by Rod
There is a new inputcsv command which you should experiment with.

 
  Reply Quote Notify of replies

 6   Liberty BASIC Code / Re: unzipping file  on: Sep 9th, 2017, 7:06pm
Started by Bob | Post by Bob
Thank you tenochtitlanuk

This makes sense to open the zip file into the directory. I could then determine the filename selected as the zip file and unzip file have the same name and automatically select the unzipped file. I'll let you know how this turns out.

My next issue would be reprogramming how I have inputted the unzipped file. While the original unzipped file is comma delimited it does have quotes around the text data (ie "AQU",1,"Track",35). I currently change this file to a csv in excel and input data with simple character for comma to delimit the data. This would not work with the original unzipped file. Any suggestions for an easy correction to the programming code would be helpful.

 
  Reply Quote Notify of replies

 7   Liberty BASIC Code / Re: unzipping file  on: Sep 9th, 2017, 2:02pm
Started by Bob | Post by tenochtitlanuk
If you've downloaded 7za.exe to the directory holding your LB code, try the following which worked for me. Don't know what files are in your zip file nor what you'll do with them. If you KNOW filenames you can now parse them. If not you may need another filedialog to select a file....
There are examples about parsing csv files and delimiter problems around this forum and elsewhere.
Code:
    '   7za.exe extracts all files from *.zip to the current directory.

    nomainwin

    filedialog "Choose zip file", "*.zip", zipFile$

    run "7za.exe e " +zipFile$



 

 
  Reply Quote Notify of replies

 8   Liberty BASIC Code / Re: unzipping file  on: Sep 8th, 2017, 10:34pm
Started by Bob | Post by robmcal
Not exactly sure how to use it myself. The command line syntax is described on this page.
https://sevenzip.osdn.jp/chm/cmdline/syntax.htm

 
  Reply Quote Notify of replies

 9   Liberty BASIC Code / Re: unzipping file  on: Sep 8th, 2017, 10:19pm
Started by Bob | Post by Bob
I have downloaded 7-zip but do not see any tutorials for programming.
 
  Reply Quote Notify of replies

 10   Liberty BASIC Code / Re: unzipping file  on: Sep 8th, 2017, 4:10pm
Started by Bob | Post by robmcal
7-zip has a command line version. You may try using that.
 
  Reply Quote Notify of replies


Rules|Home|Help|Search|Recent Posts|Notification



Donate $6.99 for 50,000 Ad-Free Pageviews!

| |

This forum powered for FREE by Conforums ©
Sign up for your own Free Message Board today!
Terms of Service | Privacy Policy | Conforums Support | Parental Controls