User Profile
Collapse
-
Don't exactly have the bandwidth or time to learn a whole new language. It was just a simple question.... -
Logging out the user/customer(CX) gets them out of the database thus unlocking it and allowing others to get into it. I've had 3 different jobs where I've had at times to log someone off so that other CX can use a file or database.
Also If I remember correctly there's a way using ASP to interface the db. You could create a web-app this way and the only thing that has it locked is the server hosting it.Leave a comment:
-
This is simple if you have a network admin account. You ether go to or remote into the offending computer. Then log-out the person using the admin account. They'll lose their work but you'll get your DB back.Leave a comment:
-
This code works. The only problem is a float that is an int... e.g in C# and C++ you values like 100f == (float)100 == 100.0, which could be in your db as ",100.,".Code:# newline1=line.replace('.,','') # newline2=newline1.replace(',.\n','') #incase last value is a period
Your second replace deletes the field and mashes the rows together screwing the db. Try instead....
...Code:# newline1=line.replace('.,','')Leave a comment:
-
Is Python like C# in respect to chaining?
I'm wondering if you can take code like.
and do something likeCode:line.replace(',.',',0.') line.replace('0.,',',0.0,') line.replace('\n',',')
I don't program python but I'm trying to help someone else on a different subject and was just interested if it was possible?Code:line.replace(',.',',0.').replace('0.,',',0.0,').replace('\n',',') -
From the code that you were showing at the beginning all your fractions were in were in a "0.#" format. But if that is an issue try...
( On a side note I think that the regex for the find would be ",\.," or ",[\.],". And to keep out the numbers and letters, ",(*[^0-9a-zA-Z\s][^\.]*[^0-9a-zA-Z\s]),"...Code:line.replace(',.',',0.') line.replace('0.,',',0.0,') line.replace('\n',',')Leave a comment:
-
You could switch the comma placement from "0.0," to ",0.0".
And generally the new line at the end of the is to keep the format of the table or database.Code:# line.replace(',.',',0.0')
If I split a database in to fields. Every field needs to have some value thus the ".".
AA|AB|AC|AD
BA|BB|BC|BD
CA|CB|CC|CD
DA|DB|DC|DD
If I have a 4 field database and...Leave a comment:
-
It looks like all your floats are "0.#" format. Why not try to replace just the single value ".,". This way the search is looking the actual value that needs replacing. And although my python isn't perfect you get the idea with...
This way you don't loose the field and...Code:# line='2.5,3,.,100,.,4.10,.,8,.,.,.,8.9,.' # line.replace('.,','0.0,') # '2.5,3,0.0,100,0.0,4.10,0.0,8,0.0,0.0,0.0,8.9,0.0'Leave a comment:
-
Try using DataGridView. They are complicated but the easiest way to editable tables.Leave a comment:
No activity results to display
Show More
Leave a comment: