Ask Your Question
1

LibreOffice Base connect to Google Sql Cloud [closed]

asked 2013-02-17 23:53:19 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hi!

I tried to connect to a Google Cloud Sql DB from LibreOffice Base. The process seems to be quite similar as is described here. The connection itself is established, no problems with that. Also using Base tool I can create a table - which is saved successfully to Google Cloud Sql. Now I'm trying to double click this newly created table and insert some data. At this point I'm getting the following error:

The data content could not be loaded.

SQL Status: 0A100

CONCUR_UPDATABLE is not implemented yet.

The SQL command leading to this error is:

SELECT * FROM `test`.`info`

Well, the error message seems to be quite self descriptive. But I want to know if there some workaround related to this issue. Maybe I can guide LibreOffice Base to not use this CONCUR_UPDATABLE option?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-17 15:51:59.112314

Comments

manj_k gravatar imagemanj_k ( 2013-06-11 15:49:22 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2013-02-18 00:12:36 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Maybe the issue is related with primary key. LibreOffice help:

image description

edit flag offensive delete link more

Comments

No, my table actually contains an ID which is set as primary key, I created new one to double check it. Still the same error described above. Thx.

chirgeo gravatar imagechirgeo ( 2013-02-18 10:57:10 +0200 )edit

Question Tools

Stats

Asked: 2013-02-17 23:53:19 +0200

Seen: 689 times

Last updated: Feb 18 '13