Ho do I deal in the sql text with fields that have a space character. For example in db biolife I have the field: Species Name both my attempts did not work:  query1.SQL.Text := 'SELECT Species Name FROM biolife'; query1.SQL.Text := 'SELECT ''Species Name'' FROM biolife';    The first one gives error, the second gives wrong result.
I have a paradox table from a legacy system I need to run a single query on.  The field names have spaces in them - i.e. "Street 1".  When I try and formulate a query in delphi for only the "Street 1" field, I get an error - Invalid use of keyword. Token: 1, Line Number: 1  Delphi V7 - object pascal, standard Tquery object name query1.
Is there a way to substring a string in Python, to get a new string from the third character to the end of the string?  Maybe like myString[2:end]?  If leaving the second part means 'till the end', and if you leave the first part, does it start from the start? How to call a SOAP web service on Android I am having a lot of trouble finding good information on how to call a standard SOAP/WSDL web service with Android. All I've been able to find are either very convoluted documents and references to "kSoap2" and then some bit about parsing it all manually with . OK, that's fine, but it's 2008, so I figured there should be some good library for calling standard web services.  The web service is just basically one created in . I would like to have IDE support for generating the plumbing classes. I just need the easiest/most-elegant way to contact a  based web service from an Android-based phone. Removing a DE field when DE is used in a data relationship I have a Data Extension field I'd like to delete, but that DE is used in an attribute group/set in Contact Builder. So is it really necessary to delete the data relationship first before I can remove the field? Seems too risky if that's the case. How to log out of a Stack Exchange site? Per the title, where is the logout button?  All the existing questions I can find refer to the previous design of the site, where hovering over your name in the top bar brought up a menu. Tikz: Arrowheads in the center Lemma vs. Theorem I've been using Spivak's book for a while now and I'd like to know what is the formal difference between a Theorem and a Lemma in mathematics, since he uses the names in his book. I'd like to know a little about the ethymology but mainly about why we choose Lemma for some findings, and Theorem for others (not personally, but mathematically, i.e. why should one classify a finding as lemma and not as theorem). It seems that Lemmas are rather minor findings that serve as a keystone to proving a Theorem, by that is as far as I can go.  NOTE: This  doesn't address my concern, so please avoid citing it as a duplicate. pfsense more than 2 isp provider is it possible to bridge more than 2 isp provider using pfsense? what router or device can bridge 2 or more isp providers in a router? i am planning to bridge at lease 5 isp providers to create a very good internet connection, what can i do to link all 5 providers in 1 router? Why should the minimal class be avoided? How to prevent Windows 10 from automatically adding keyboard layouts (i.e. US keyboard) Update: this is a lengthy post, you can     Note: The quick language list refers to the list in the screenshot below, accessible throught the shortcut Win + Space bar  I have two languages for windows spell check in my system, English (United States) and French (Switzerland), but despite both languages being properly configured with "Swiss French" input keyboard, US Keyboard input keeps appearing on this list:    Here's the settings for English (United States) language, you can see the only input is "Swiss French":    Same for Français (Suisse), the only input is "Swiss French":    In the Control Panel, both are also set as Swiss French:    All my settings are set to use "language list":     Here's a few things that I already tried:   I already managed to remove it by some language configuration gymnastics, by adding and removing languages, it always eventually comes back I have already done this:  There's no mention of US Keyboard in my registry settings either:     Please help, I'm desperate, this is my third computer with Windows 10 and they all do the same thing. I saw there are various manga with Akame ga KILL! in their names.  The ones I have found are:       Which one should I read if I want to continue the storyline of the anime? I downloaded and installed Ubuntu from the official site. However, I don't know if I installed the 32-bit or 64-bit version.  In Windows 7 I could right click My Computer and it listed which version it was.  Is there an easy way to check in Ubuntu? Were there any improvements to the second Death Star (other than the change in exhaust port) that we know of? What should I do if I want to be able to run a given program regardless of my current directory? Should I create a symbolic link to the program in the /bin folder? How can I install Visual Studio? How can I install Visual Studio?    I'd prefer to use it in Wine or PlayOnLinux if possible. 70s UK science fiction TV show with time travel and telepathic cat I'm trying to identify a science fiction series on UK TV during the 70s, but I can only recall the following:   A party of adults and children. There was a woman with a telepathic bond to her cat: she could look into its eyes to see what it had seen. Time travel was involved. I think it may have been inadvertent or uncontrolled time travel. On one occasion the party encountered an Elizabethan seaman who demanded to know if Elizabeth was still queen. They party replied "err... yes" because they didn't want to have to explain time travel. I recently upgraded to Ubuntu 13.10, with the new keyboard handling system. The little "switch keyboard" option does not let me set it to Alt+Shift. How can I get this keyboard binding, as I have absolutely no interest in using the Mac-esque Super+Space combo? Prevent VLC from starting a new instance every time a media file is opened Can I solve system of differential equation in a matrix form? Writing ISO 19139 compliant XML metadata from spreadsheet? I am looking at a way to migrate the metadata from a spreadsheet into ISO 19139 compliant XML metadata documents for a collection of shapefiles. I can parse the data out of the spreadsheet into strings without issue however I am getting lost on how to take those strings and use them to populate the elements.   This example:  covers most of what I want to do, however I would need to generate the tree beforehand based on the ISO 19139 schema. PyXB seems to have schema bundles for OpenGIS but I would like some insight on how to connect everything. How can I run a different command but with the same arguments? For example, I edit and then run the same source.   vim arbit.py python arbit.py   I know I could run it from within vim, but I want a general solution on Bash. I keep finding situations where I reuse arguments.  How can I do that?